I just recently started working with MYSQL, I've never had a need to put my database in anything other than Access until these datafeeds started coming out! I started out just playing with the datafeed from LS and got good results. Didn't take me long to realize Access would not do the job.

Anyway, Do the indexes on MYSQL work similar to Access? Example, Do number fields query faster than text?
Which text fields query faster, a Varchar or a fixed length text field?
Are there any limits to the number of indexes on tables in MYSQL (besides space)?