 | | | MySQL Denormalized | MySQL Denormalized 2006-06-30 - By Brent Baisley
Back
A specific character that would occupy less space? You mean like using lower
case instead of upper case? All characters use the same
amount of space (unless your using Chinese or something).
I don't think reducing the number of columns will help. Usually you take other
performance enhancing measures first, like
structuring it to use fixed length records. You should probably use InnoDB and
index the fields you normaly retrieve. Since InnoDB
stores the data with the index, it doesn't need to access the actual table
unless you are pulling data that isn't indexed.
While denormaliztion is certainly applicable and desired in some case (whoever
saw a database in fifth normal form!), you are not
denormalzing, your combining data elements. There are so many other things you
can try before you unstructure your data. If you're
going to unstructure your data, you might as well compress it too. Heck, you
might even look into separating out the data you don't
search on into a separate compressed table, and have a 1-1 relation. Kind of a
search table and a "detail" table.
I don't know which response time you are trying to keep to .01 or lower. If it
's end to end, you probably want to look at your
network. Network latency can be the biggest culprit.
-- -- Original Message -- --
From: "Jan Gomes" <jangs@(protected)>
To: "mysql" <mysql@(protected)>
Cc: "johnlist" <johnlist@(protected)>
Sent: Friday, June 30, 2006 3:28 PM
Subject: Re: MySQL Denormalized
John Hicks wrote:
>I don't see a question here.
>
>But that won't stop me from giving a little advice :)
>
>It is generally more important to keep things simple (by not
>denormalizing) than to try to optimize performance by complicating
>things significantly.
>
>Moreover, I can't see how combining several columns into one will
>improve performance. I would think it will slow things down whenever you
>have to retrieve data, particular if you query against anything in column 3.
>
>And now you say you want to save disk space by compressing the field
>separators in your combined column?
>
>Forget it all! Go back to a fully normalized design. If you have
>problems, post them here
>
>
I kind of disagree on what you said regarding denormalization, but believe me
when I say that I have
experienced a 90% improvement on performance with that.
As I said before, my table has +20 million entries; if it was normalized this
number would be around 20
billion, since it would be a 1 - N relation.
Off course I don't make any selections based on column 3, but only by the table
's keys.
Forget that!!! Runing for normalization would not be viable for me. I need a
response time lower than 0.01 sec.
(and I've been achieving less than that)
However I would like to make a better use of this column's space, once I use
two only characters for separators.
Here's my question: Is there anyway I could minimize that? Is there any
specific character that would occupy
less space?
Once again thank you very much
==============
Atenciosamente,
Jan Gomes - jangs@(protected)
>Jan Gomes wrote:
>> Hy Guys,
>>
>> I needed denormalized my table to obtain high performance, but i want best
appropriate the >space.
>>
>> I joint two column (of the JOIN) intro one column with two separadores (#
and ;)
>>
>> Example:
>> ID | column_1 | column_denormalized
>> 1 | Test | 1#20202;5#1000101;
>>
>> It has some method to minimize the space(disk space) required for this
separadores ? Like >some character that i
>> can use for minimize the table size?
>>
>> PS: The table has 20.000.000 of rows with 2 GB data length.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=brenttech@(protected)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|