[PHP] High ID (unique, auto increment) causes slow responses on PHP (MySQL)

I've built a certain system where every time new user enters it creates a guest row on guests table. he also gets an identifying cookie. The table contains several fields, one of them is ID which is auto increment and unique When he does a certain action it gets recorded in the done_action

Re: [PHP] High ID (unique, auto increment) causes slow responses on PHP (MySQL)

Just use SERIAL id and you will be good ;) (that's an alias for something like BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY) It shouldn't bother you as long as it works. On Sat, Jun 13, 2009 at 9:16 PM, דניאל דנון danondan...@gmail.com wrote: I've built a certain system where every

Re: [PHP] High ID (unique, auto increment) causes slow responses on PHP (MySQL)

2009/6/13 דניאל דנון danondan...@gmail.com:  I've built a certain system where every time new user enters it creates a guest row on guests table. he also gets an identifying cookie. The table contains several fields, one of them is ID which is auto increment and unique When he does a