Hi,

Do we need a primary key column in the database table when we want to 
call the method Session.delete(String query)?

According the SessionImpl the delete operation is issuing following statements:

   ....
   List list = find(query, values, types);
   ....

this creates a list of objects and calls: 

for ( int i=0; i<size; i++ ) delete( list.get(i) );

to delete objects one by one.

Is there a way to execute the delete operation without creating a object 
list which results from find(...)? i.e. execute DELETE operation 
directly on the database?
Because, I'm working on some data which has about few millions of  data
this could be a performance problem. could you let me know how to improve
some performance with delete operation.

regards
Lilantha



--------------------------------------------------------------------------------------------------
This message, including any attachments, contains confidential information intended 
for a specific individual and purpose, and is intended for the addressee only.  Any 
unauthorized disclosure, use, dissemination, copying, or distribution of this message 
or any of its attachments or the information contained in this e-mail, or the taking 
of any action based on it, is strictly prohibited.  If you are not the intended 
recipient, please notify the sender immediately by return e-mail and delete this 
message. 


-------------------------------------------------------
This SF.Net email sponsored by Black Hat Briefings & Training.
Attend Black Hat Briefings & Training, Las Vegas July 24-29 -
digital self defense, top technical experts, no vendor pitches,
unmatched networking opportunities. Visit www.blackhat.com
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel

Reply via email to