* [EMAIL PROTECTED]
>
> I have a question on how MySQL JOIN has effect on query (search)
> performance:
>
> Our database consists of about 250.000 datasets (rows).
> Right now, all of the 150 columns are in one big table.
>
> However, we do have certain columns that are empty for most rows (for
>
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the s
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the s
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the s
Hello
I have a question on how MySQL JOIN has effect on query (search) performance:
Our database consists of about 250.000 datasets (rows).
Right now, all of the 150 columns are in one big table.
However, we do have certain columns that are empty for most rows (for
example information of the s
Sounds about right.
How have you got your my.cnf set?
Have you got RAID on you HDD?
Simon
-Original Message-
From: Florian Wilken [mailto:[EMAIL PROTECTED]]
Sent: 23 May 2002 10:17
To: [EMAIL PROTECTED]
Subject: MySQL Query Speed
Hello
our database consists of one table with approx
Hello
our database consists of one table with approx. 150 columns.
We have a query going over 11 columns (most tinyint, int and some varchar)
Out of 217237 rows the query found 56 matches.
Without Indexing, the query took 2,55 seconds.
With Indexing, the query took 0,04 seconds.
The database and
