On Wednesday 10 January 2001 20:58, [EMAIL PROTECTED] wrote:
> 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
> SELE
You don't need to select all the data to get the number of rows. Try
this:
select count(*) as total from products where $product_query;
Then use total instead of num_rows.
Be sure the elements in your where clause are properly indexed.
[EMAIL PROTECTED] wrote:
>
> Could someone suggest some op
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 inf
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 disp
4 matches
Mail list logo
