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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
