On Thu, 6 Apr 2000, Dido Sevilla wrote:
..
> MySQL is more feature-rich. They have some pretty cool extensions to
> SQL92 such as regular expression select and such. Also should be more
> efficient on more powerful computers. Haven't used it much but I'm
> trying to figure it out because it looks cool.
You'll stay away from regexp select if I were you. It doesn't use the
index and so forces a full-table scan. When you're working with
10-million-row tables like I am, you'll abjure anything that does a full
table scan.
> As for PostGres, I will say that it is pretty scalable. I once got the
> thing to work on a 386 with 8MB RAM! Try doing that with MySQL! It
> system requirements are definitely lower. You don't even need POSIX
> threads to use it, but that's also a disadvantage because lots of
> requests would benefit from a threaded architecture.
MySQL can run on 4MB. Check the manual for how to configure it. You won't
be able to compile it on 4MB though, the sql_yacc.c (SQL parser) requires
about 180MB (!) of RAM/virtual memory to compile with -O6 optimizations.
---------------------------------------------------------------------
Orlando Andico <[EMAIL PROTECTED]> +63 (2) 937-2293
Mosaic Communications, Inc. +63 (917) 531-5893
Any sufficiently perverted technology is indistinguishable from Perl.
-
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
