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
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
suggest a possible setup.
6. Is char() a better choice than varchar() in terms of speed when queries
are run (we are aware of the fact that char() requires more disc space) ?
It would be very helpful for us if you could help us with the above questions..
Thank you very much.
Best regards.
Florian
