(sorry my english)
i have the same bug in my script.
I often run : CREATE TABLE new_table AS (SELECT * FROM old_table) with_data
new_table is very fast
You can anticipate the problems with : SELECT * FROM storage() WHERE "table" IN ('old_table', 'new_table') . Look heapsize column
heapsize is big for old_table (slow table), small for new table (speed table).
I have not yet found the OPTIMIZE command as in mysql
Pierre
--
1G6
52 route de bischwiller
67300
Schiltigheim
Société de Services et de Formations en Logiciels Libres
http://1g6.biz
Tél : 06 64 63 70 35
De: "Edgar Mejia" <omejiasq@gmail.com>
À: users-list@monetdb.org
Envoyé: Mercredi 27 Novembre 2013 13:48:21
Objet: Table very slow
HI, i have one table as 15 millions of rows of all 2013. I all days delete the las 2 months and return to reload them again. Today is table is very slow, one select count takes more that 2 minutes, when it would normally to a few seconds. I migrate this information to a new table and this table if works fine and is very fast. What i need to do for to fix this and how i to fix this table slow?
Thansk
Edgar M
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list