Members   Search   Help    Register    Login   Home

Show: Today's Messages  :: Show Polls :: Message Navigator

What is faster: Columns or Rows [message #496] Thu, 21 December 2006 04:32  willybnl2 Messages: 6 Registered: December 2006 Junior Member Let's say I have a table that contains text (still varchar) in a lot of languages (let's say 50 languages). I would only use this to do selects the whole day. And i always need to search for 1 key in 2 or 3 of this languages with 1 query and display this to the user. What would be faster: ID english lang2 lang3 1 text text text (so I get both long vertical/horizontal table) OR ID lang text 1 english text (so I get very long vertical table) Normalization tells me the last, but using MySQL 4 i noticed the top one is faster for as much i can test... but what should be faster (maybe I'm testing wrongly ) [Updated on: Thu, 21 December 2006 04:43] Report message to a moderator

	What is faster: Columns or Rows By: willybnl2 on Thu, 21 December 2006 04:32
	Re: What is faster: Columns or Rows By: carpii on Fri, 22 December 2006 00:00
	Columns are faster then rows By: willybnl2 on Fri, 22 December 2006 18:34
	Re: What is faster: Columns or Rows By: bluesaga on Sun, 24 December 2006 15:10
	Re: What is faster: Columns or Rows By: willybnl2 on Sun, 24 December 2006 20:05
	Re: What is faster: Columns or Rows By: bluesaga on Mon, 25 December 2006 06:37
	Re: What is faster: Columns or Rows By: willybnl2 on Mon, 25 December 2006 10:07
	Re: What is faster: Columns or Rows By: bluesaga on Mon, 25 December 2006 20:33

Previous Topic:	OR & AND?
Next Topic:	MySQL Performance References

Goto Forum:

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [ ]