Hello all:
Thanks for all answers and ideas. Finally I've solved the problem by
reading and reviewing ..... times the MySQL manual. In it I've found
'*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
problem: I had (unconsciously) activated the ODBC trace. Besides in my
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
worse still.
Josemi
----------------------------------------------------
José Miguel Serrano escribió:
>
> 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. It is imposible work in that situation.
>
> I have an VMware machine for triying programs, and surprisingly the
> access is good. I have tried install new (and old again) MyODBC
> connectors, uninstall some silly programs, but eventualy the speed no
> change in my computer.
>
> The server is a Red-Hat 9 machine with MySQL Server 4.1.12. My
> computer is an 1,5 Gh. processor, with 512 Mb. of RAM. The Operating
> Sistem is W 2000 Professional.
>
> Could someone help me?. Any ideas will be good, and I´ll pay attention.
>
> Best regards,
>
> Josemi
>
>
>
