db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hidde Boonstra [Us Media]" <hidde.boons...@usmedia.nl>
Subject Re: Torque is very slow to do a .copy of an object :( Why?
Date Thu, 12 Apr 2007 12:46:44 GMT
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...



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

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

View raw message