Hello:
I just realized I accidentally had the controller
on server 1 running.
Here are the statistics:
1. Only using server 1, controller and generation
code on the same machine.
This takes about 2 minutes.
2. Running the controller on server 2 and
the generation code on server 1.
This takes about 13 minutes.
3. Running the controllers on both servers 1 and 2.
Running the generation code on server 1.
This takes hours to finish.
Why would case 3 be so much longer than case 2 above?
Thanks,
Neil
--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Neil
Aggarwal
Sent: Saturday, June 30, 2007 1:38 PM
To: 'Sequoia general mailing list'
Subject: [Sequoia] Pitiful performance with more than one backend
Hello:
I have a piece of Java code that inserts about 4000
objects into a Sequoia database using JPOX.
There are two controllers for the database each located
in a separate data room. They are running Sequoia 3.0
beta 2 built from CVS.
First, I went to server 1 and ran the controller on
it (Keeping the controller on server 2 off). Then,
I went to server 1 and ran my code to generate the
objects. It took about 2 minutes to create all the
entries in the database.
Next, I stopped the controller on server 1
and ran the controller on server 2. Keeping the controller
on server 1 off, I went to server 1 and ran my code to
generate the objects. That took hours to finish.
I expected it to take a little longer to run over
the network but not a 100x or so difference.
As a test, I dumped the mysql database from server1
to a text file. Then, I ran a command line client
on server 1 and connected it to the mysqld running
on server 2. When I imported the text file
containing the SQL statements, it ran almost
instantaneously. To me, this test shows network
delays are not causing the peformance hit.
Any ideas on how to diagnose this?
Thanks,
Neil
--
Neil Aggarwal, (832)245-7314, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
