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