efits.
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 uppe
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
>> a
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.
Thanks.
==
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
--
MySQL General Mailing List
For list
with-unix-socket-path=/tmp/mysql.sock
--with-mysqld-ldflags=-all-static --enable-assembler
Thanks everybody!!
======
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
> > The query is:
> > SELECT * FROM table
> > where i
ity.
PS.: Pardon me for some thing, my english is not very good
> Jan Gomes wrote:
>
> >Hy Jay,
> >
> >Thanks for you attention.
> >
> >Show you my structure and EXPLAIN:
> >
> >CREATE TABLE `table` (
> > `id_table1` int(10) unsigned NOT NULL def
| key_len | ref | rows | Extra |
+--- +-+--+--+-+
| table_idx1 | 4 | NULL | 72 | Using where|
++-+--+--+-+
> Please post your exact table schema using SHOW CREATE TABLE, and your
> exact query, along with an EXPLAIN SELECT for the query.
>
&g
Hy Guys,
I have a simple structure of tables, howewer has 50 million of registers and
2,5 GB of data.
The table is MyIsam and has 4 integer fields and 1 Text field, one primary key
with two integer fields
and one btree index with one integer field.
There is a select in this table using an index
