Home extremely slow table operations on a table with few rows but large column contents
Reply: 0

extremely slow table operations on a table with few rows but large column contents

user382
1#
user382 Published in June 22, 2018, 11:33 am

I have a table with only 9 rows and 10 columns. Three of these columns are VarBinary and contain about 12-30 MB of data in each column for each row. Now even simple updating of one row takes more than 20 minutes and Sql times out. Even a select statement takes about 40 seconds unless I excluded the Varbinary columns from the query

Any suggestions. Thanks

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.316669 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO