Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    24

    choosing between access and mysql

    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?

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    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.).
    Thanks,

    Matt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •