2007/3/14, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > I want to catch all the queries my application asks to the DB (the > ones that goes throught Model->save), append this SQL queries to a > flat file, and run all the queries together using just one connection.
I don't see how that will reduce the number of connections to your database, since Cake will already connect to the database before any Model->save() is (can be) called. If you want to reduce workload on your database server by delaying DML, I'd go for a solution at the DBMS level (for example, create a master/slave replicated database, where the master db processes slow DML and the slave produces query results fast). Regards, Martin -- Martin Schapendonk, [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
