[ale] project help - postgres or mysql?

[Brian J. Dowd]

I built a MySQL DB  in which one table was over 5,000,000 (about 80 
alphanumeric chars) records of five fields
*Really* fast. Of course, YMMV

>Project I'm ramping up on will involve porting a microcrap sql server db
>to either postgres or mysql.  No stored procedures on the sql server side,
>thankfully.  Just tables and indexes.
>
>The current db has a total of 227,626 rows, 249 tables.  Only 4 tables are
>over 10000...most are either in the 10s or hundreds.  Largest table is
>89890.
>(for list of counts, see http://sourceillustrated.com/projects/tblcnt.html).
>
>My initial thoughts are to use MySql, but wanted to put the question forth
>to the list.  I think mysql would have no problem handling this size, but
>want to be sure.
>
>Would postgres be a better choice?
>
>Thanks!
>
>John
>
>
>
>
>_______________________________________________
>Ale mailing list
>Ale at ale.org
>http://www.ale.org/mailman/listinfo/ale
>
>  
>


_______________________________________________
Ale mailing list
Ale at ale.org
http://www.ale.org/mailman/listinfo/ale