You can use KEY() which will add extra keys to the table.
--Joe
On Wed, Jan 10, 2001 at 12:58:37PM -0700, [EMAIL PROTECTED] wrote:
> Could someone suggest some options here for performance improvement?
>
> I have a table with about 300,000 entries/records by 7 columns/fields. All of
> the information varies from entry, but only one field can be declared as UNIQUE.
>
> I have PHP perform SELECT queries on the table, and I need to display the
> results in a format of: "viewing $top to ($top+$depth) of $numrows found"
>
> I haven't found a way to determine $numrows without performing a second SELECT
> in this format:
>
> $numrows = mysql_num_rows (db_query("SELECT * FROM products WHERE
> $product_query"));
> if ( $numrows < $depth ) { $depth = $numrows; }
> $qid = db_query("SELECT * FROM products WHERE $product_query LIMIT $top,
> $depth");
>
> So, this takes about twice as long as it would without figuring the $numrows.
> Does anyone have any suggestions as far as what can be done to speed this up?
> Assume that the table in question is optimized with indexing and UNIQUE values.
>
> Thanks.
>
> Lee Howard
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
---
Joe Stump
PHP Programmer
www.Care2.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
