use the entityengine.xml you find in version 4.0 replace derby with localpostgres
Brendan Vogt sent the following on 11/11/2007 9:54 AM: > Can I please see you entityengine.xml file for version 4 please using the > postgres database. > > I'm a bit confused with regards to the delegators. > > > -----Original Message----- > From: BJ Freeman [mailto:[EMAIL PROTECTED] > Sent: Sunday, November 11, 2007 6:51 PM > To: [email protected] > Subject: Re: Databases > > 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 >>> >> >> >> > > > >
