harrison, thanks for you mail,
I think mysql uses way too much memory (overhead) to store my data.
How much overhead do you think it is using? Each row is 61 bytes in
geldbrief, which is *exactly* the amount needed for the datatypes you
have.
[...]
Now if you take 61 * 2449755 (number of rows)
Hi,
A few questions for you.
On Friday, August 6, 2004, at 06:17 AM, Jan Kirchhoff wrote:
I was just wondering if anybody has been using very large HEAP-tables
and if there are ways to have mysql use the memory more efficient:
(I have no experience with all heap-tables but using them as temporary
Philippe Poelvoorde wrote:
Hi,
I changed a few columns, bidsize and asksize are integer now, and i
changed ticknumber to smallint unsigned.
At first I used the ticknumbers by the feedserver, now I count up to
65,000 and then reset the counter back to 0. I need that additional
column to handle mu
Hi,
I changed a few columns, bidsize and asksize are integer now, and i
changed ticknumber to smallint unsigned.
At first I used the ticknumbers by the feedserver, now I count up to
65,000 and then reset the counter back to 0. I need that additional
column to handle multiple ticks within one sec
Philippe Poelvoorde wrote:
Maybe you should try to normalize your table,
'symbol' could have its own table, that would reduce data and index.
And then try to reduce the size of your rows, bidsize and asksize
should be in integer I think. Maybe 'float' would be enough.
What represents the 'quelle'
Maybe you should try to normalize your table,
'symbol' could have its own table, that would reduce data and index.
And then try to reduce the size of your rows, bidsize and asksize should
be in integer I think. Maybe 'float' would be enough.
What represents the 'quelle' column ?
Is kurszeit necess
I was just wondering if anybody has been using very large HEAP-tables
and if there are ways to have mysql use the memory more efficient:
(I have no experience with all heap-tables but using them as temporary
tables...)
I just started testing with 2 heap-tables on a development-system (p4
3.2ghz
