Re: Creating objects in the database

I was not aware that the database was creating 20000 separate
transactions. If anyone has an idea of how I can modify my code to
ensure that I do not create 20000 seperate transactions, please assist
me on that.

 

From: William Pietri [mailto:[email protected]] 
Sent: Monday, February 09, 2009 7:42 PM
To: Open discussion about the Prevayler project.
Subject: Re: [Prevayler-discussion] Creating objects in the database

 

Just to be clear, each object is saved in its own transaction, so that's
20000 separate transactions.

William

Khayundi, Peter wrote: 

The objects are created in a single transaction.
 
-----Original Message-----
From: Klaus Wuestefeld [mailto:[email protected]] 
Sent: Friday, February 06, 2009 11:04 PM
To: Open discussion about the Prevayler project.
Subject: Re: [Prevayler-discussion] Creating objects in the database
 
Also: Are you creating 20000 objects in a single transaction or in
20000 separate transactions?
 
 
On Fri, Feb 6, 2009 at 6:49 PM, Klaus Wuestefeld
<[email protected]> <mailto:[email protected]>  wrote:
  

	Are you doing SCADA or OLTP?
	 
	 
	On Fri, Feb 6, 2009 at 3:24 PM, William Pietri
<[email protected]> <mailto:[email protected]> 
	    

wrote:
  

		Khayundi, Peter wrote:
		 
		I am doing some timings with the Prevayler database. I
inserted 20000
		      

items
  

		into the database and timed this operation. The
experiment was
		      

repeated 10
  

		times. The resulting times differ widely and have a high
standard
		      

deviation.
  

		Does anybody have an explanation as to why the same
experiment should
		      

have
  

		such widely different timings?
		 
		 
		 
		Hi, Peter. My first two guesses: other IO on the same
disk and Java
		      

garbage
  

		collection. You can reduce problems with the first by
using a
		      

separate disk,
  

		and with the latter by giving Java lots more RAM than
necessary.
		      

There are
  

		also assorted tunings you can do, but those depend on OS
and JDK
		      

version.
  

		 
		William
		 
		--
		William Pietri - [email protected] - +1-415-643-1024
		Agile consulting, coaching, and development:
http://www.scissor.com/
		We'd love feedback on our new blog:
http://agilefocus.com/
		 
		 
		 
		 
		 
		 
		      

------------------------------------------------------------------------
------
  

		Create and Deploy Rich Internet Apps outside the browser
with
		Adobe(R)AIR(TM)
		software. With Adobe AIR, Ajax developers can use
existing skills and
		      

code
  

		to
		build responsive, highly engaging applications that
combine the power
		      

of
  

		local
		resources and data with the reach of the web. Download
the Adobe AIR
		      

SDK and
  

		Ajax docs to start building applications
		      

today-http://p.sf.net/sfu/adobe-com
  

		_______________________________________________
		To unsubscribe go to the end of this page:
	
http://lists.sourceforge.net/lists/listinfo/prevayler-discussion
		_______________________________________________
		"Databases in Memoriam" -- http://www.prevayler.org
		 
		 
		      

 
------------------------------------------------------------------------
------
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and
code to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
To unsubscribe go to the end of this page:
http://lists.sourceforge.net/lists/listinfo/prevayler-discussion
_______________________________________________
"Databases in Memoriam" -- http://www.prevayler.org
 
 
 
The University of Fort Hare subscribes to an e-mail disclaimer. Please
click on the following URL to read further:
http://www.ufh.ac.za/disclaimer/
 
 
 
------------------------------------------------------------------------
------
Create and Deploy Rich Internet Apps outside the browser with
Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and
code to
build responsive, highly engaging applications that combine the power of
local
resources and data with the reach of the web. Download the Adobe AIR SDK
and
Ajax docs to start building applications
today-http://p.sf.net/sfu/adobe-com
_______________________________________________
To unsubscribe go to the end of this page:
http://lists.sourceforge.net/lists/listinfo/prevayler-discussion
_______________________________________________
"Databases in Memoriam" -- http://www.prevayler.org
  

 




The University of Fort Hare subscribes to an e-mail disclaimer. Please click on the following URL to read further:
http://www.ufh.ac.za/disclaimer/

------------------------------------------------------------------------------
Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM)
software. With Adobe AIR, Ajax developers can use existing skills and code to
build responsive, highly engaging applications that combine the power of local
resources and data with the reach of the web. Download the Adobe AIR SDK and
Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com

_______________________________________________
To unsubscribe go to the end of this page: http://lists.sourceforge.net/lists/listinfo/prevayler-discussion
_______________________________________________
"Databases in Memoriam" -- http://www.prevayler.org