Hi, I'm not too familiar with the BAT concept. Regardless, I want to know more about the SQL equivalents. We have need for a 300 million recors DB of about 500 GB. We insert about 1000 records per seconds. or about 100 millions record per day, for 3 days. We 'roll' the data by time, deleting the tail end of the tables, but the the 'deletes' are too slow. So, we are looking at better DB or data storage patterns (one that would allow a quick DROP-table-like or file.delete() response time). So, as I look at MonetDB, I have some questions: 1-What is the insert speed relatively to other DBs? 2-What is the delete speed relatively to other DBs? 3-What is the insert speed degradation with the addition of indexes? 4-What is the delete speed degradation with the addition of indexes? Also, in the forum, I saw some discussions about size. We may remain on a 32 bits kernel, so: 5-The 2 gigs limit on BATs, is that records count is byte size? A performance constraint was also highlighted: "the performance degradation starts when MonetDB has to access BATs larger then the available memory" 6-In our case, with 300 millions records, how big would be the BATs? Last question, lucky 7: 7-Do you think MonetDB is at all a good choice for our high-thoughput highly volatile data? Thanks! ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs