Query runs much faster in MS Access via ODBC?!!

[Ben]

I have a query that takes over a minute to run with the mysql client. The
same query takes seconds in MS Access via ODBC.

I have no clue what is going on. Can someone kindly shed some light on
this.

I am using:
mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98 (i32)
mysqld-nt Ver 4.0.12-nt for NT on i32

Thanks.

[John]

Hi, Ben:

We'll need more information otherwise it's impossible to tell.

What is your table structure? What are the indexes and primary keys?

Are you sure your structures are exactly the same in MS Access as they
are in MySql?

Are both tables loaded with about the same amount of data?

Finally, what is the SQL statement you are running (post both versions
if not identical under both DBs)?

-John
Ben wrote:

I have a query that takes over a minute to run with the mysql client. The
same query takes seconds in MS Access via ODBC.

I have no clue what is going on. Can someone kindly shed some light on
this.

I am using:
mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98 (i32)
mysqld-nt Ver 4.0.12-nt for NT on i32

Thanks.

[John]

Hi, Ben:

We'll need more information otherwise it's impossible to tell.

What is your table structure? What are the indexes and primary keys?

Are you sure your structures are exactly the same in MS Access as they
are in MySql?

Are both tables loaded with about the same amount of data?

Finally, what is the SQL statement you are running (post both versions
if not identical under both DBs)?

-John
Ben wrote:

I have a query that takes over a minute to run with the mysql client. The
same query takes seconds in MS Access via ODBC.

I have no clue what is going on. Can someone kindly shed some light on
this.

I am using:
mysql Ver 12.18 Distrib 4.0.12, for Win95/Win98 (i32)
mysqld-nt Ver 4.0.12-nt for NT on i32

Thanks.