Torgny Bjers wrote:
FSA wrote:
hi, i have a big php script with alot of db inserts and updates, what i
want to do it's to log all this db commands into a table. I was wonderig
if there is a better way to do this than the insert into logs_table the
actual queryes.
ty
Depending the amount of queries and the number of times the actual
script is loaded, your logs could flood very easily and bog down the
server. These notions of logging EVERYTHING is sometimes worse than
actually allowing the culprit script to run slowly or execute lots of
queries. 4 GB of logfile says way less than actually reading through the
script and checking to make sure that the queries are proper. If you are
still intent on logging these queries, I would go with your logs_table
idea and limit the fields and field lengths to the extreme and index it
tightly to make sure that it does not grow too much in size, that means,
char or varchar, and definitely no text/blob fields.
If this is a web script, one idea would be to only trigger the logging
for a specific set of IP numbers, so that only your own browser triggers
the logging, but it is left dormant while others browse.
additionally you might want to not log each query in full but just store
a count of the number of times a given query was run - but this would probably
only be useful if you where using prepared queries - which is recommended if
your doing lots of the same ... then again your DBMS might not support that
(me I use firebird mostly - which is better ;-)
Regards,
Torgny
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
