SEO

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

Velen 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.
>
>
I'm not sure what you mean when you say it is "running fine". If that
means that you are getting the right result but it's taking too long,
that's one thing. If you mean that the speed is fine until you get VB6
involved, that's another.

Try the query in MySQL itself and see how long it takes to display the
data. If the speed is perfectly acceptable in raw MySQL but dreadful
when you use VB6, you've pretty much proven that VB6 is the problem, not
MySQL. In that case, you may want to ask on a VB6 newsgroup for hints in
making it perform better.
> Can anyone suggest a better alternative to Msflexgrid or how to improve the speed on msflexgrid?
>
> Thanks.
>
> Regards,
>
>
> Velen
>
>
--
Rhino

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
>