This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 11%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
I am facing issues while retrieving varbinary data from sql server tables ,Performance is taking a toll , 4 lakh records are taking around 20 hrs to read and write into target db tables
@Sujan Athelli Welcome to Microsoft Q&A thanks for posting your question.
I understand you are facing performance issues while retrieving varbinary data from SQL Server tables. There could be several reasons for this, such as network latency, database design, or query optimization
Retrieving large amounts of varbinary data can indeed be challenging and impact performance significantly.
Here are some strategies that might help improve the performance
If you frequently query varbinary data based on certain criteria, consider creating indexes on those columns to speed up the retrieval process
Avoid using SELECT * queries, which retrieve all columns from the table, including the varbinary columns. Instead, select only the necessary columns. If you need to work with varbinary data, consider retrieving the IDs first and then fetching the varbinary data only for those specific records
Instead of processing all records at once, batch the operations to process a smaller number of rows at a time
Regards
Geetha
@GeethaThatipatri-MSFT thanks for the reply, I have tried the options which you have mentioned , but still I am facing the same slowness in the select statement, do we any other method to make the select statement faster while fetching varbinary data.Total record count is 4 lakh
Total record count is 4 lakh
That's 400,000, right? And how large is the average size of a record? If it's "only" 1 MB then you have a traffice of 400 GB and that can take some time.
Hi Olaf , Thanks for the reply,Can you suggest me an alternate approach.