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 <velen@biz-mu.com> 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
>