I went from MS SQL 7 to postgresql and have been there since. That is not a recommendation compared to other DB's I have no reason to look for another DB.
Brendan Vogt sent the following on 11/11/2007 4:38 AM: > 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 >> > > > >
