As far as i know, using IN( SUBQUERY ) will give very poor performance,
especially if the record set returned by the large query is really large.
try to use a join instead of WHERE IN( XXX )..
Im not sure why its that much better in INNODB though...
Foo Ji-Haw wrote:
Hi all,
Just want to
Something is double escaping the strings.
Check if GPC magic string is enabled (apache's auto escaping).
Also check if your code manually escapes the strings.
Halid Faith wrote:
Hello
I use mysql 4.1.16 and php4.3.10 and phpmyadmin2.7 and apache-2.0.53 on
FreeBSD5.3
I add any text as data