Pardon me, i think I din't express myself properly.
I did not only combining data elements.
My structure was:
Table_1{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Table_2{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
}
Being a relationship between table_1 and table_2 1-N.
For each entrance in table_1 it would have among 100-1000 register in table_2.
After many tests I was with the following structure:
Table{
id_table1 (int)
COLLUM 1 (int)
COLLUM 2 (int)
COLLUM 3 (TEXT) (UNION COLLUM 1 and 2 of table_2)
}
What it brought me storage and speed benefits.
What I imagined was a caracter to use as separating that it occupied little
space, but seems not to exist.
Thanks for all.
==============
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: "mysql" <[email protected]>
> Cc: "johnlist" <[EMAIL 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 - [EMAIL 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/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
