[PLUG] 1,500,000 records for MySQL?

Shannon C. Dealy dealy at deatech.com
Fri Jun 7 19:31:36 UTC 2002


On Fri, 7 Jun 2002, Matt Alexander wrote:

[snip]
> So here's my initial thought...  A web-based front-end that accesses a
> MySQL database with the images stored on a large disk array.  I would like
> a web-based front-end because about 30% of our company runs Linux on their
> desktops, and they'll need access from time to time as well.  I'm leaning
> towards MySQL simply because I'm the most familiar with it, but I'm not
> sure how well it would handle 1.5 million records.  Has anyone had
> experience with MySQL databases this large?  If MySQL is not the best
> choice, then I'll gladly use whatever will do the best job.
>
> Thank you for any feedback you might have.
[snip]

I don't want to get into holy war here, but based on everything I've read
about the implementation of MySQL, while it does fine for many things, it
still lacks full SQL support, and it has some holes in it's implementation
that will allow it to mess up your database while performing transactions.
Given the above, and the fact that PostgreSQL does provide a full SQL
implementation (which will probably make it easier to migrate to from
your old system) and correct handling for transactions, PostgreSQL is the
only free DB that I would use for commercial work.


Shannon C. Dealy      |               DeaTech Research Inc.
dealy at deatech.com     |          - Custom Software Development -
                      |    Embedded Systems, Real-time, Device Drivers
Phone: (800) 467-5820 | Networking, Scientific & Engineering Applications
   or: (541) 451-5177 |                  www.deatech.com





More information about the PLUG mailing list