Very slowly ODBC conexion

--------------010905030102060908060206
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


Hello all:

I'm using mysql for about 2.5 years, and never past like this: We have a =

table with about 18,000 rows, and connect it by ODBC to an Access=20
application. In quite all computers the speed is very razonable, but in=20
MY computer goes very slowly. It is imposible work in that situation.

I have an VMware machine for triying programs, and surprisingly the=20
access is good. I have tried install new (and old again) MyODBC=20
connectors, uninstall some silly programs, but eventualy the speed no=20
change in my computer.

The server is a Red-Hat 9 machine with MySQL Server 4.1.12. My computer=20
is an 1,5 Gh. processor, with 512 Mb. of RAM. The Operating Sistem is W=20
2000 Professional.

Could someone help me?. Any ideas will be good, and I=B4ll pay attention.=


Best regards,

Josemi



--------------010905030102060908060206--

Re: Very slowly ODBC conexion

José Miguel Serrano wrote:

>
> Hello all:
>
> I'm using mysql for about 2.5 years, and never past like this: We have
> a table with about 18,000 rows, and connect it by ODBC to an Access
> application. In quite all computers the speed is very razonable, but
> in MY computer goes very slowly.

How do you mean it 'goes' slowly?
Do you mean it connects slowly?
Or maybe it connects fast but then returns data slowly?
How about some examples of what you're doing?

- ODBC connection string
- SQL of query
- table definitions

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Very slowly ODBC conexion

--------------070708000002070107080908
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable


Hello all:

Thanks for all answers and ideas. Finally I've solved the problem by=20
reading and reviewing ..... times the MySQL manual. In it I've found=20
'*24.1.14.7. Why Does MyODBC Perform Poorly, and Also Make a Lot of Disk =

Activity for Relatively Small Queries?*' where explain exactly the=20
problem: I had (unconsciously) activated the ODBC trace. Besides in my=20
computer had the SQL.LOG with 2 Gb.

I have only stooped the trace, and my querys goes like a shot!.

Thanks again. In other side, thanks because you have tried understand my =

writting English, (like *conexion* word :-[ ). My speaking English is=20
worse still.

Josemi

----------------------------------------------------
Jos=E9 Miguel Serrano escribi=F3:

>
> Hello all:
>
> I'm using mysql for about 2.5 years, and never past like this: We have =

> a table with about 18,000 rows, and connect it by ODBC to an Access=20
> application. In quite all computers the speed is very razonable, but=20
> in MY computer goes very slowly. It is imposible work in that situation=

>
> I have an VMware machine for triying programs, and surprisingly the=20
> access is good. I have tried install new (and old again) MyODBC=20
> connectors, uninstall some silly programs, but eventualy the speed no=20
> change in my computer.
>
> The server is a Red-Hat 9 machine with MySQL Server 4.1.12. My=20
> computer is an 1,5 Gh. processor, with 512 Mb. of RAM. The Operating=20
> Sistem is W 2000 Professional.
>
> Could someone help me?. Any ideas will be good, and I=B4ll pay attentio=
n.
>
> Best regards,
>
> Josemi
>
>
>

--------------070708000002070107080908--