The first question that occurs to me is, Why on earth would you want an app to display 2500 rows? You must have one incredible monitor with a resolution beyond my wildest dreams! I would look into the LIMIT predicate and use it to grab say 50 rows at a time, or fewer, and post a marker so you know how to interpret the Next and Previous commands that you provide on the form.
Just a thought. Arthur On Thu, Apr 24, 2008 at 12:44 PM, Velen <[EMAIL PROTECTED]> wrote: > 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 >
