Access: slow search on linked tables

Hello everyone.

I have a MySQL table with about 18,000 records with MySQL ODBC 5.1
connected to a front-end Access.

If I open the table in Access directly, shows me all results.
If I do a search with eg Ctrl-B on the Primary Key of the table, I
take ages to reach the record sought.

Example:
The key of the table is the ID field, a consecutive number [1 ..
18000]. When you open the table and try to find the ID 16500, is
found, but in a very long time.

The key, by definition, has an INDEX B-Tree, but it seems this is
ignored when searching to access (if not, do not understand).

How can I optimize this search?

Note:
My users are used to search directly in Access on the table / view with Ctrl + B

Thank you very much.

--
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: Access: slow search on linked tables

I am not familiar with this Ctrl-B you mention, you don't mean Ctrl-F do
you?

When you linked the table, did you make sure Access recognised the
primary key? It's behaving as if it does not know there is an index.

What happens if you write a select query for the same key and run it?

John Bonnett

-----Original Message-----
From: delahuerga delahuerga [mailto:delahuerga@gmail.com]=20
Sent: Friday, 15 January 2010 4:17 AM
To: myodbc@lists.mysql.com
Subject: Access: slow search on linked tables

Hello everyone.

I have a MySQL table with about 18,000 records with MySQL ODBC 5.1
connected to a front-end Access.

If I open the table in Access directly, shows me all results.
If I do a search with eg Ctrl-B on the Primary Key of the table, I take
ages to reach the record sought.

Example:
The key of the table is the ID field, a consecutive number [1 ..
18000]. When you open the table and try to find the ID 16500, is found,
but in a very long time.

The key, by definition, has an INDEX B-Tree, but it seems this is
ignored when searching to access (if not, do not understand).

How can I optimize this search?

Note:
My users are used to search directly in Access on the table / view with
Ctrl + B

Thank you very much.


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