i've a big database 8 Gb with few tables all necessary indexes and many read-only access i'v 4Gb ram a fast disk/network
update and delete are once at day and few record so i can stop the access in that time. I think to modify these parameters, which values to use?? PRAGMA default_cache_size = ?? PRAGMA case_sensitive_like = 1 PRAGMA page_size = ??? PRAGMA temp_store = MEMORY ??? i don't think to get tables in memory can improve the performance because the search operate only by index any others idea? thank ------------------------------------------------------ Passa a Infostrada. ADSL e Telefono senza limiti e senza canone Telecom http://click.libero.it/infostrada19dic06 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
