JOINS: MySQL Query Speed

2002-05-28 Thread Florian Wilken
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

JOINS: MySQL Query Speed

2002-05-28 Thread Florian Wilken
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

JOINS: MySQL Query Speed

2002-05-28 Thread Florian Wilken
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

JOINS: MySQL Query Speed

2002-05-28 Thread Florian Wilken
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

Re: JOINS: MySQL Query Speed

2002-05-28 Thread Roger Baklund
* [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 example