Thanks BJ, what is available is the 'target' m/c only with latest MySQL, no backup has been taken for this dev env. Since I work primarily with ofbiz, theres no other dataset to reference.
On Tue, Aug 31, 2010 at 11:02 PM, BJ Freeman <[email protected]> wrote: > 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. >>>> >>>> >>>> >>> >> >> > -- Regards, Varun Bhansaly
