Database suggestions?

[Ken Ray]

Hey, everyone, I need some database advice (or suggestions). I'm currently
working on a product that uses Valentina client/server where the database
has 86 tables, with a couple of dozen tables holding 10,000 - 100,000
records.

Valentina has been good for us but we're getting perfomance issues where the
server slows down over time to a point that is unacceptable. We're currently
trying to work through them with the guys at Paradigmasoft, and if we can
work through them successfully, we'll stay with Valentina (we really LIKE
Valentina). But to play it safe, we'd like to see if there are alternatives
to Valentina that will give us the performance we would need in the event we
can't make it work.

SO.......

In addition to the specs above, the server needs to run on either an OS X or
Windows server (the server will be a top-of-the line (or near
top-of-the-line) machine, and will have 1GB of RAM or higher), and the
clients are either OS X or Windows XP. Additionally, we need to have the
ability to run the client and the server on the same machine.

Now that you know what we're looking for, can anyone suggest any
alternatives for Valentina we should look at, and why they suggest that
database platform? I know I've seen people talk about MySQL and PostgreSQL
on the list, as well as SQLLite, but I don't know enough of the pros and
cons to make an educated decision, which is why I've turned to this list.

So what do you think?

Ken Ray
Sons of Thunder Software
Web site: http://www.sonsothunder.com/
Email: kray at sonsothunder.com