Hello, thanks for fast DB! I need you suggestion on table limits on one DB.
I need record each 5 min count of in/out/size of each uid's (can be 100 000 of uid's and more), each uid generate for year 105 210 record. I think create tables = number of uid's (because if write to one table it will be 1 052 100 000 records for year and it will be slow). All of this tables are not necessary all the time, just every 5 min to write records (not to all tables), or get records (not from all tables). Is it possible load and unload tables to not waste memory? or better use flat files? Thanks for any clue... Regards Valentin -- 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.
