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

2009-06-14 Thread Andrew Ballard
On Sat, Jun 13, 2009 at 3:34 PM, Stuart wrote: > 2009/6/13 דניאל דנון : >>  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 increm

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

2009-06-13 Thread Stuart
2009/6/13 דניאל דנון : >  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

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

2009-06-13 Thread Nitsan Bin-Nun
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, דניאל דנון wrote: > I've built a certain system where every time new user enters it

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

2009-06-13 Thread דניאל דנון
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"