Hello Pavel,
Tuesday, March 2, 2004, 2:05:44 PM, you wrote:
PL 398(rows) * 37(average) = 14KB, sorting is more faster
PL etc...
I have been reading over the MySQL Manual today (specifically the
Optimisation sections) and one thing caught my eye:
In some cases, MySQL can read rows from the
Note! IMHO
Creating test table:
---
CREATE TABLE `thread` (
`threadid` int(10) unsigned NOT NULL auto_increment,
`site_user_id` varchar(32) NOT NULL default '',
`boardid` tinyint(3) unsigned NOT NULL default '0',
`subject` varchar(200) NOT NULL default '',
Hello Pavel,
Tuesday, March 2, 2004, 2:05:44 PM, you wrote:
PL Note! IMHO
[snip]
Wow. I'm speechless - thank you, that was probably the single most
useful post I've ever read on this list. You sir are a genius.
PL Change `site_user_id` FROM VARCHAR(32) TO CHAR(32)
It was a char(32) - it