Andrew Piskorski wrote: >On Sun, Dec 19, 2004 at 12:09:08PM +0100, Bertrand Mansion wrote: > >> For web applications (sqlite being now the default database for PHP5), >> COUNT(*) >> performance is more important than INSERTs and DELETEs performance. The >> obvious > >That sounds VERY much like a matter of opinion. I strongly suspect I >could find plenty of high-powered database backed website developers >who would argue the exact opposite.
That's not an opinion, that's the way it is for the large majority of web applications. I am not talking about the few exceptions that do INSERTs on every pages instead of using log files... Bertrand Mansion Mamasam