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

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... :-)

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

Gianluca_Venezia wrote:[color=blue]
> 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... :-)[/color]

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.

--
This sig left intentionally blank

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

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