[ODBC] form linked to odbc tables with "high" number of record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gianluca_Venezia - 11 Feb 2005 12:46 GMT

Talking about high number of record seem ridiculus, if this number is
about 88.000

but
when I open a form, linked via ODBC to a MYSQL table, the open and the
use of that form is slow, and very slow if the form has combo
controls.

I have a order form, and a combo control for custemer codes.
Order table counts 88.000 records, customer tables has 1.500 records.

Is there a "correct" way, for performance, to manage this "normal"
situation?

Gianluca (not so happy... :-)

Reply to this Message

Trevor Best - 12 Feb 2005 10:58 GMT

> Talking about high number of record seem ridiculus, if this number is
> about 88.000
[quoted text clipped - 11 lines]
>
> Gianluca (not so happy... :-)

http://www.trevor.easynet.co.uk/AccFAQ/perf.htm

Also try basing your form on a query that returns only one record, roll
your own search for the form as well.

Signature

This sig left intentionally blank

Reply to this Message

Gianluca_Venezia - 12 Feb 2005 17:16 GMT

Thanks for your link, that has confirmed what I have find about combo
boxes.
After all, and after my direct test, I finally accept to forgot combo
box on large db.
I think to use a search form based on query, and when an user insert
for a customer id code the event/situations will be:
- case 1. (ex not in list) - no id find, open an insert form
- case 2. (ex in list) - if id find, collect data from user table

Bye
Gianluca

Reply to this Message