So what would you recommend? Currently I use SQL Server 2005, but I am looking for a similar database that is free of use. What would you advise? When I have loads of users using the system at once, I do not want it to crash or be slow.
-----Original Message----- From: BJ Freeman [mailto:[EMAIL PROTECTED] Sent: Sunday, November 11, 2007 12:39 PM To: [email protected] Subject: Re: Databases You have few issues here Database size and Ofbiz scalability. You also have the consideration of the CPU speed and amount of memory. Users depends on what they are doing. Remember that the DB is not doing much except Storing and retrieving data. so thing like Store procedures is not considered. Though some jbc drivers do create temporary stored procedures to deal with select statements. So putting the db on a separate server, is an option when you are starting to see performance issues. As far as Olap look at the work in specialpurpose\bi folder in the trunk svn. Brendan Vogt sent the following on 11/11/2007 12:43 AM: > Hi, > > Of all the databases that Ofbiz cab run on, which is the most suitable > database? I am currently running on Postgres. I think (can't remember > correctly) but think Ofbiz comes with something like Olap, which I don't > think it is supported in Postgres. > > I am looking at a database that can handle thousands of users at any one > time. > > Brendan >
