Arie Nugraha napsal(a):
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN mst_author AS
a ON
Arie Nugraha wrote:
Hi list,
I Have a problem with my query that fetch about 22.000 records from
database, the query is like this :
SELECT SQL_CALC_FOUND_ROWS DISTINCT b.biblio_id, b.title,
a.author_name FROMbiblio AS b LEFT
JOIN biblio_author AS ba ON b.biblio_id=ba.biblio_id LEFT JOIN
Hi all
I'm using Firebird as the back-end for a web site. The search engine is
written in PHP, using bog-standard SQL queries. Here's the problem:
In order to make the results listing work well, the page needs to know how
many records match the search criteria. This is so I can
a) display '1 to
like a clunky solution, but it has helped somewhat.
- Original Message -
From: Evan Morris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, November 26, 2003 12:01 PM
Subject: [PHP-DB] Optimizing query for public search engine
Hi all
I'm using Firebird as the back-end for a web