the first is to isolate if ofbiz is causing anything by removing it from
the equation.
so do a equivalent restore of data from the machine that ofbiz resides
on to the target that MySQL resides on and time.
you can do this by saving the MySQL data of a current db that has ofbiz
structure and data then loading like above to the db on the target machine.
That give you a bench mark of the DB by itself.
then setup ofbiz to a local db with the same setting as the remote one
and see what the load time of the db is from ofbiz.
that should give you a fair estimation where the problem is.
=========================
BJ Freeman <http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation
<http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
varun bhansaly sent the following on 8/31/2010 10:10 AM:
I have tried loading over network as well as from local.
Are talking of mysqldump restore as well ?
On Tue, Aug 31, 2010 at 10:30 PM, BJ Freeman<[email protected]> wrote:
if I read this correct you have introduced many variables.
1) have you tested loading a MySQL db over the network in this
configuration, list a restore, not using ofbiz?
2) have you tested loading a local MySQL db using ofbiz?
=========================
BJ Freeman<http://bjfreeman.elance.com>
Strategic Power Office with Supplier Automation<
http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com<http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
varun bhansaly sent the following on 8/31/2010 5:32 AM:
Hi,
I have setup 10.04 branch in my dev enviornment, with MySQL db
server(v5.1.46 on a separate VM) with utf8 encoding on Open Suse 11.3
having
4 processors& 2 gb ram.
Encoding in entityengine.xml is set to utf8.
Database creation with demo data takes minimum 40 minutes. Is this an
acceptable for db creation given above configuration ?
PS : My previous MySQL server with latin1 encoding with 6 CPU and 12 gigs
ram used to take 10 mins.
