hi List
The problem is like this
There are two Tables A and B.
what i want to do is find out all the records where a.id != b.id
Both tables have close to 1 records. so for every a.id it has to
check table b 1 times and that is what is creating problems.
bcos this query takes hell lot of time to execute and mysql stops
responding after some time.
So is there some other way to find out records present in one table but
not in other.
Thanks you can mail me at [EMAIL PROTECTED] also
Pradeep
__
http://dating.zeenext.com Log on to nextDATE. It's the next best thing to doing it.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
