MySQL Forums
Forum List  »  Performance

Re: Query Performance
Posted by: Felix Geerinckx
Date: October 03, 2005 12:32PM

Sergej Shablakov wrote:

> But still, what I'm really concerned is that once I start adding these virtual fields (JOIN)
> performance rapidly goes down and even on a few rows (or records) with 12-13 fields it takes
> forever.

Please post EXPLAIN SELECT ... \G
for your full query with realistic data at your earliest convenience.

> If I need to join let's sat 30 columns - I need to find another way out.

I think 31 is the limit in a standard MySQL 4.1

--
felix
Please use BBCode to format your messages in this forum.

Options: ReplyQuote


Subject
Views
Written By
Posted
2018
October 03, 2005 12:17AM
1344
October 03, 2005 02:28AM
1316
October 03, 2005 09:44AM
1394
October 03, 2005 11:08AM
1358
October 03, 2005 11:39AM
1277
October 03, 2005 11:50AM
1256
October 03, 2005 12:03PM
Re: Query Performance
1256
October 03, 2005 12:32PM
1234
October 03, 2005 12:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.