Hi, first of all I want to express my gratidude to you. I really enjoy working with your database.
> drop all objects; > @memory; > create temporary table test(id int primary key, name varchar); > create index idx_1 on test(name); > insert into test select x, x || space(1000) from system_range(1, 10000); > @memory; > drop table test; > @memory; Kay, this might be a workaround, thx. > > Why is the index like 6-7 times larger than the temporary table? > > Java needs quite a lot of memory. Is it an option for you to create a > regular table instead of a temporary table? > > > And why is it completely stored in memory, discounting the value set > > for CACHE_SIZE? > > My idea was that temporary tables are usually very small and need to > be very fast. That's why indexes of temporary tables are kept in > memory. I can change that if required, but that's how it is currently. > I will add a feature request, but will not yet change that unless > others also request to change it. It's not a breaking change, but may > be unexpected for others if I change it. Yes, I see the point. But in fact you do allow cached temporary tables and I thought this was a nice way of just skipping the DROP TABLE command for ordinary tables at the end of my program. It's not a problem att all to use persistent tables in my program, but I'ld allways had to keep in mind to really DROP these tables at the end and it just doesn't look as nice as it would with temporary tables. I dont know, but wouldn't it be great if one were able to chose whether one wants a cached or in-memory index? Finally, I'm still wondering why the in-memory index is >10 times larger than the cached index? Java needs a lot of memory, but thats really a good many. Thanks in advance (also for http://groups.google.com/group/h2-database/browse_thread/thread/15814309be95cd07/b11e4fa0a99415bb#b11e4fa0a99415bb). Regards, Philipp -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
