In the last episode (Jul 20), Ravi Raman said: > ok, first actual question to the list, hope someone can help: > the following query - > > select pn.number, c.ID, c.cost, c.days_valid, c.description from > pinnumbers pn, cardtype c where pn.cardtypeID = c.ID and pn.tmaster = 0 > order by c.ID, pn.number > > returns: 55033 rows in set (4 min 10.11 sec) Are pn.cardtypeID and c.ID declared the same? That can sometimes cause problems. -- Dan Nelson [EMAIL PROTECTED] --------------------------------------------------------------------- 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
- Re: Bug report: FULLTEXT index corrupt... Carsten Gehling
- Re: Bug report: FULLTEXT index cor... Sergei Golubchik
- SV: Bug report: FULLTEXT index... Martin Larsen
- Re: Bug report: FULLTEXT index... Carsten Gehling
- Re: Bug report: FULLTEXT i... Sinisa Milivojevic
- Re: Bug report: FULLTEXT i... Sergei Golubchik
- Re: Bug report: FULLT... Carsten Gehling
- Re: Bug report: F... Sergei Golubchik
- The Best Platform Dave Carter
- EXPLAIN question Ravi Raman
- Re: Bug report: F... Dan Nelson
- Re: Bug report: F... Carsten Gehling
- Re: Bug report: F... Sinisa Milivojevic
- Re: Bug report: FULLTEXT i... Carsten Gehling
- Re: Bug report: FULLTEXT i... Fournier Jocelyn [Presence-PC]
- Solution (but only a temporary one) Re... Carsten Gehling
- RE: Bug report: FULLTEXT index corrupts the... Simon Green
- Re: Bug report: FULLTEXT index corrupt... Fournier Jocelyn [Presence-PC]