Environment: Windows XP
MySQL 3.51 Driver.
I set up an ODBC connection System DSN (localhost).
When I open my Record Set in VB6 it takes almost a minute! What am I doing
wrong?
PS It used to work on Winows98.

Thanks for any help.
Joel

"Joel" <joel [at] ecsnj.com> wrote in news:PBRYf.23705$fQ6.8846 [at] trnddc03:

>
> Environment: Windows XP
> MySQL 3.51 Driver.
> I set up an ODBC connection System DSN (localhost).
> When I open my Record Set in VB6 it takes almost a minute! What am I
> doing wrong?
> PS It used to work on Winows98.
>
> Thanks for any help.
> Joel

why are you using an ANCIENT version of MySQL? MySQL 5 has been out for
over six months, not to mention the great MySQL 4 that has been out for
years.

I intend to. But first I want to get the application running as well as
before then I'll upgrade it....Any reason for it running slow?


"Good Man" <heyho [at] letsgo.com> wrote in message
news:Xns979C7957D20Fsonicyouth [at] 216.196.97.131...
> "Joel" <joel [at] ecsnj.com> wrote in news:PBRYf.23705$fQ6.8846 [at] trnddc03:
>
> >
> > Environment: Windows XP
> > MySQL 3.51 Driver.
> > I set up an ODBC connection System DSN (localhost).
> > When I open my Record Set in VB6 it takes almost a minute! What am I
> > doing wrong?
> > PS It used to work on Winows98.
> >
> > Thanks for any help.
> > Joel
>
> why are you using an ANCIENT version of MySQL? MySQL 5 has been out for
> over six months, not to mention the great MySQL 4 that has been out for
> years.
>

Joel wrote:
> Environment: Windows XP
> MySQL 3.51 Driver.
> I set up an ODBC connection System DSN (localhost).

ODBC slows things down a good bit, sometimes as much as 100% slower than
direct connection.


> When I open my Record Set in VB6 it takes almost a minute! What am I doing
> wrong?

Skip VisualBasic and use PHP for web application and C/C++ if you do other
applications.


//Aho

asking "why is this slow" without know the query, the table layout, and
a lot of other things, is like asking why is grass green.

All right let me give you a little more background. I transferred a VB6
application using MySql 3.51 Driver from Windows 98 platform to XP
I downloaded MySQL set up the ODBC driver connection. Yet when I run the
program what use to take a split second to open a record set now takes about
a minute! What am I doing wrong?



"no-1" <onedbguru [at] firstdbasource.com> wrote in message
news:1144343141.797363.113820 [at] t31g2000cwb.googlegroups.com.. .
> asking "why is this slow" without know the query, the table layout, and
> a lot of other things, is like asking why is grass green.
>