VB.net 2003 with SQL SERVER data loaded very slow.

[ganeshvkl]

hi everyone,
My project is storing Images in database and retrieve in grid, it is working
fine. when the record are high in number (around 3500) , it takes more than 5 minutes to load the form.

can anyone help me?
Thanz in Adv.
Ganesh

[kenobewan]

How large are the images? Wouldn't it be better to have paging or a catalog of thumbs so that all the images didn't have to load at once?

[ganeshvkl]

How large are the images? Wouldn't it be better to have paging or a catalog of thumbs so that all the images didn't have to load at once?

Thanx for 'r Response.

How to do Paging or Catlog of Thumbs (the image size is around 50 Kb) ?

[kenobewan]

Thanx for 'r Response.

How to do Paging or Catlog of Thumbs (the image size is around 50 Kb) ?

My original thought was that if you have paging you do not have to display all the images at once. Paging is simply set to true and works in asp.net 2.

However if it is the query that is taking so long you will need to optimize that, rather than selecting all the images at once. So is your prob the loading of the images, your query or both?