Another thought I had just after hitting "send" - if you're concerned about adding to the time it takes to load a page due to logging, you should consider using an "INSERT DELAYED" syntax if you can. That causes the database to immediately return a success message to the client (probably your webserver in this case) while it buffers the statement to be performed at the next opportunity. See the manual page for more info and caveats: http://dev.mysql.com/doc/refman/5.0/en/insert-delayed.html
You could use this regardless of whether or not you choose to add indices, even. Dan On 10/21/06, Brett Harvey <[EMAIL PROTECTED]> wrote:
Does not having a Primary Key and No indexes really speed up inserts significantly? We have a log table. it has the fields, cart_id, referer, remote_ip, server_name, user_agent, company, action, type, and value that we are tracking vistor log information for our ecommerce site. Every page is tracked that a person goes to in the log file. Currently we have about 500,000 rows. So I am wondering if we are really saving that much by not having a Primary Key and no indexes. Thanks! -- -------------------------------------------------------------------------------- /Brett C. Harvey; /Creative-Pages.Net, President; /Facility Management Systems, CTO (www.fmsystems.biz); /Lasso Partner Association Member ID #LPA135259 (www.omnipilot.com/www.lassopartner.com); -------------------------------------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]