More questions

[Doug Evans]

After fighting with the ODBC thing, I can now run a query from MS Access to
my table in Mysql. I have approximately 250,000 records, and 12 fields. The
records contain data about part numbers.

If I query for a part number, it takes approx. 6 seconds to get an answer.

1. If this were on a Unix box, would the query take less time?
2. Using the windows version, is there a way to speed things up, such as
indexing?


Another item: In Access, one can set up a multiple field index, to eliminat
duplications. Can that be done in Mysql?

Thanks, Doug