diff -r 9f21bab39f42 -r 4a4892eec172 metadataengine/server/src/mdssqliteconnection.cpp
--- a/metadataengine/server/src/mdssqliteconnection.cpp	Tue May 11 16:36:55 2010 +0300
+++ b/metadataengine/server/src/mdssqliteconnection.cpp	Tue May 25 13:10:05 2010 +0300
@@ -75,8 +75,8 @@
 
 void CMdSSqLiteConnection::OpenDbL( const TDesC& aDbFileName )
     {
-    _LIT8( KMdsSqlDbaConfig, "cache_size=8000; page_size=2048; encoding=\"UTF-16\";");
-    _LIT8( KBlacklistSqlDbaConfig, "cache_size=4000; page_size=1024; encoding=\"UTF-16\";");
+    _LIT8( KMdsSqlDbaConfig, "cache_size=2000; page_size=2048; encoding=\"UTF-16\";");
+    _LIT8( KBlacklistSqlDbaConfig, "cache_size=1500; page_size=1024; encoding=\"UTF-16\";");
 
     delete iDbFileName;
     iDbFileName = NULL; // in case AllocL leaves
@@ -639,6 +639,15 @@
         }
     }
 
+void CMdSSqLiteConnection::DoAnalyzeL() 
+    {
+    _LIT( KAnalyze, "ANALYZE;");
+    
+    RRowData emptyRow;
+    CleanupClosePushL( emptyRow );
+    ExecuteL(KAnalyze, emptyRow);
+    CleanupStack::PopAndDestroy( &emptyRow ); 
+    }
 
 TInt CMdSSqLiteConnection::DeleteAndReCreateDB( const HBufC* aDbFileName,
                                                 const RSqlSecurityPolicy& asqlSecurityPolicy,