Todays databases are designed to handle a crapload of queries, so don't be afraid to take advantage of this. Just make sure you've got indexes on the right columns and your queries are using those indexes. You could possible create another table which is optimised to hold any database changes made along with a timestamp.
Cheers, Adam On Jan 4, 6:44 pm, "Juan Luis Baptiste" <[email protected]> wrote: > Hi, > > It's possible to expose a web service that receives some data on a > Cake shell? I have a cake shell that monitors a log and reads from it > some data and compares it with another data in a database to do some > stuff. The problem is that if the data in the database get's updated, > the only way to get it into the cake shell without querying the > database each time the shell reads something from the log file is by > restarting the cake shell. I was thinking that I could expose a web > service method on the cake shell that receives the new data it needs > to compare, so it could be invoked from the cake web application that > saves the data into the database. Is this possible ? or anyone else > has another solution that avoids querying the database on each read > from the log ? > > Cheers, > Juan Luis --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
