View Single Post

   
  #1 (permalink)  
Old 04-24-2008, 06:08 PM
Velen
 
Posts: n/a
Default Display more than 2500 rows

Hi,

May be it's not the right forum i'm posting to.

I have a Mysql Query : Select a.code,b.description, b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and a.id='5' order by a.id

This is running fine but when using VB6 to display it in a Msflexgrid, it's a nightmare! It will take about 3-5 mins to display around 2500 rows.

Can anyone suggest a better alternative to Msflexgrid or how to improve the speed on msflexgrid?

Thanks.

Regards,


Velen

Reply With Quote