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: [EMAIL PROTECTED] _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
