db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From philipina <sono_...@hotmail.com>
Subject Re: Torque is very slow to do a .copy of an object :( Why?
Date Thu, 12 Apr 2007 14:34:56 GMT

Hi,

One other object has a reference to the object I want to copy but the object
I want to copy has no reference (foreign key) to any other object.

Alain



Hidde Boonstra [Us Media]-2 wrote:
> 
> Hi Alain,
> 
> does your object have many relations (foreign key constraints)? I just 
> looked into the copy method and I see it does a deep copy, so if you 
> have many relations, or many related entries in your database, these 
> will all be copied into your copy. This might explain why it gets slower 
> when there is more data...
> 
> Greetz,
> 
> Hidde.
> 
> philipina wrote:
>> Hello,
>> I'm using torque to connect to my Mysql database.
>> I'm trying to improve performence of my application and I saw that torque
>> is
>> taking more than 600 ms to execute a command like:
>> ---------------------------------------------
>> Object1 myCopiedObject1 = myObject1.copy();
>> ---------------------------------------------
>> 
>> Torque is only slow if I have a lots of data in my DB. I cannot
>> understand
>> this! a copy should only do the work in memory and not access the DB.
>> 
>> Why is it soo slow? Any idea to speed-up this copy?
>> 
>> Thanks in advance.
>> 
>> Alain 
> 
> -- 
> Us Media B.V.
> Stadhouderskade 115
> 1073 AX Amsterdam
> 
> t: 020 428 68 68
> f: 020 470 69 05
> www.usmedia.nl
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Torque-is-very-slow-to-do-a-.copy-of-an-object-%3A%28-Why--tf3565099.html#a9960722
Sent from the Apache DB - Torque Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message