TalkPHP - View Single Post

Wildhoney · 10-24-2007, 07:48 PM

...And just to tie this thread up. You may wish to consider taking the advice of the posts further up and not serializing the data. LIKE is a slow piece of functionality for MySQL. How about using the IP address in its own designated column and making it a unique primary key? That way once MySQL finds the IP it's looking for, it won't continue trawling the entire table to see if there's another one.

10-24-2007, 07:48 PM	#10 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	...And just to tie this thread up. You may wish to consider taking the advice of the posts further up and not serializing the data. LIKE is a slow piece of functionality for MySQL. How about using the IP address in its own designated column and making it a unique primary key? That way once MySQL finds the IP it's looking for, it won't continue trawling the entire table to see if there's another one. __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.