-1

I have more over 10000 (varbinary/image) entries in a SQL Server table and I want to retrieve/fetch all that data immediately. Is it possible? I am using ASP.NET as my front end. If I use data table, I list etc methods its takes at least 2 to 3 minutes.

Purpose Finger Print attendance maintain system (ZkTecko device), frontend ASP.NET windows application.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SHAFEEK BABU
  • 11
  • 2
  • 1
    Network might be fast, but they still take time to move data. – Dale K Nov 03 '19 at 07:39
  • Is any other solution? because we are took all data from database and match with appropriate finger from device – SHAFEEK BABU Nov 03 '19 at 07:43
  • 1
    Seems to me it would be quicker to pass the single image from the device to the server and match it there? – Dale K Nov 03 '19 at 07:44
  • I already tried that ways , but i couldn't get proper result,The Finger print device match with some algorithms , its have appropriate DLL files , – SHAFEEK BABU Nov 03 '19 at 07:47
  • 1
    I'm sure it can work... just need to fix your issue. Transferring 10,000 images to the client sounds very wrong. And will always take some time. – Dale K Nov 03 '19 at 07:48
  • But i tried , if i register 1 finger template using device , next time same finger template getting another value using var Binary – SHAFEEK BABU Nov 03 '19 at 07:53
  • You'd need to open a new question and provide a lot more information in order for anyone to be able to help you. The answer to this question is, no, to transfer a large amount of image data will always take time. – Dale K Nov 03 '19 at 07:54

1 Answers1

0

In order to improve the performance you could do following steps:

1) You should save the image path in the image field in the database and upload image to server instead of storing image in database. Because image size is usually large it takes more storage and takes time to fetch data.

2) Secondly you should use pagination at frontend or database end instead of fetching all the record at once. This approach will also improve the performance of your system.

I would recommend if you use datatable with the pagination at database end.

Muhammad Aftab
  • 1,098
  • 8
  • 19