==
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
.
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
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.
Thanks.
==
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
--
MySQL General Mailing List
For list
--with-mysqld-ldflags=-all-static --enable-assembler
Thanks everybody!!
==
Atenciosamente,
Jan Gomes - [EMAIL PROTECTED]
The query is:
SELECT * FROM table
where id_table2 in (1652272,1652293,1652316,1652362
|
+--- +-+--+--+-+
| 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.
Thanks!
-jay
Jan Gomes wrote:
Hy Guys,
I have
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 default '0',
`id_table2` int(10) unsigned NOT NULL default '0',
`field1`smallint(5) unsigned
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