Hi, > 1.Can we monitor how much space is taking each table in the > database.Any tools available to trace the each table space? if not, > any other way to instrument this setup ?
No. You can only estimate it. What you could do is run SCRIPT TO ... and then check how many bytes each table uses in the script file. This will roughly be the size required in the database; except for the index size. There is no way currently to measure the index size, sorry. > Can we save memory by limiting the log file. Yes, see SET MAX_LOG_SIZE. In the current version, the log file is at least 10% of max(size(data.db), size(index.db)). In the next release the MAX_LOG_SIZE will be used always. > Why the index file was > taking double space than data? Maybe you have many indexes, or the indexes are on large columns (VARCHAR for example)? > 3. Can we keep the database in memory and index's in file based. Was > it supported? No, but keeping the indexes in memory is supported. See CREATE MEMORY TABLE http://www.h2database.com/html/grammar.html#createtable "Memory tables are persistent, but the index data is kept in the main memory, so memory tables should not get too large." Regards Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
