PDA

View Full Version : choosing between access and mysql

fallacy
05-22-02, 12:35
hope somebody can provide some insight:

i'm trying to develop an app. where there will be many reads/queries but relatively few insertions and edits. overall, i'm not too concerned with insertion and update performance, but only lookup performance.

any thoughts as to which one would be faster?
MattR
05-23-02, 12:17
I would think MySQL would be a LOT faster. Plus if cost is a factor you can run it on linux and only have to pay for a box and not an OS as well.

That, and MySQL can handle a lot larger databases/more users/etc.

But remember that MySQL's SQL is a bit limited (no fks, subselects, stored procedures, triggers, etc.).