Re: Table very slow

(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 ----- Mail original ----- De: "Edgar Mejia" À: 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