3 ms·
Using it with LIMIT makes sense, and I forgot you were doing that. BTW, you were doing this to avoid using too much memory at the database, but by doing this (
by ars 17y ago
Using it with LIMIT makes sense, and I forgot you were doing that.
BTW, you were doing this to avoid using too much memory at the database, but by doing this (assuming it's PHP; you didn't say) you are loading the result set twice into webserver memory.
Obviously it worked for you, maybe the webserver had more free memory.
- petercooper 17y agoIt did (though less total memory). Significantly, though, the memory use was ephemeral at the application server end. Do the collation, push to a memcache server, server, and die :-)