LIKE clause really slow. LIKE clause really slow. We use Mysql.pm to access our mySQL database and do queries.
Visitors are able to search books by subject, author and title.
Thus all search queries hit one and only table. I think that joins will further slow down searches. Note that there are 30,000 authors, so even an author table will be quite big. Appreciate your help, Chris Lambrou Copyright 1999-2001 Open Source Development Network. All rights reserved.