From: Edmund L. <el...@in...> - 2003-06-10 02:06:02
|
Is there anyway to pass pure SQL through to the database? I was thinking that if performance is an issue, then under some circumstances, it would be nice to be able to override selected object methods and use pure SQL to do things, I think. The specific example I'm thinking of is a situation where a table needs to have N rows inserted into it, and the data are from other tables. Right now, I'd have to write a loop to do this, emitting at least N queries. If I could pass SQL through, I could replace the loop with just one SQL statement. Is this a good idea? ...Edmund. |