dimanche 22 mars 2015

How to increase sqlite performance

I want to increase sqlite performance. Tried this



class SqliteSettingsMiddleware(object):

def process_request(self, request):
cursor = connection.cursor()
cursor.execute("PRAGMA threads = 2")
cursor.execute("PRAGMA page_size = 2048")
cursor.execute("PRAGMA temp_store = MEMORY")
cursor.execute("PRAGMA default_cache_size = 20000")


But I think it is not increasing performance. My concern is with faster reading speed. Can someone tell me I am doing it right.???


Aucun commentaire:

Enregistrer un commentaire