Re: Pysqlite tables in RAM

2006-10-05 Thread John Machin
Ranjitha wrote: > Fredrik Lundh wrote: > > > Ranjitha wrote: > > > > > I want to store my data in a database on the disk. I also want to be > > > able to reload the tables into the RAM whenever I have a lot of disk > > > accesses and commit the changes back to the database. > > > > using the cache

Re: Pysqlite tables in RAM

2006-10-05 Thread Ranjitha
Fredrik Lundh wrote: > Ranjitha wrote: > > > I want to store my data in a database on the disk. I also want to be > > able to reload the tables into the RAM whenever I have a lot of disk > > accesses and commit the changes back to the database. > > using the cache_size and synchronous pragmas sou

Re: Pysqlite tables in RAM

2006-09-29 Thread Fredrik Lundh
Ranjitha wrote: > I want to store my data in a database on the disk. I also want to be > able to reload the tables into the RAM whenever I have a lot of disk > accesses and commit the changes back to the database. using the cache_size and synchronous pragmas sounds like a better way to trade rel

Re: Pysqlite tables in RAM

2006-09-29 Thread John Salerno
Ranjitha wrote: > Hi all, > > I'm relatively new to python and am facing a problem with database > access > > I want to store my data in a database on the disk. I also want to be > able to reload the tables into the RAM whenever I have a lot of disk > accesses and commit the changes back to the d

Re: Pysqlite tables in RAM

2006-09-29 Thread Steve Holden
Ranjitha wrote: > Hi all, > > I'm relatively new to python and am facing a problem with database > access > > I want to store my data in a database on the disk. I also want to be > able to reload the tables into the RAM whenever I have a lot of disk > accesses and commit the changes back to the d

Re: Pysqlite tables in RAM

2006-09-29 Thread Bruno Desthuilliers
Ranjitha wrote: > Hi all, > > I'm relatively new to python And to databases ? > and am facing a problem with database > access > > I want to store my data in a database on the disk. I also want to be > able to reload the tables into the RAM whenever I have a lot of disk > accesses and commit t

Pysqlite tables in RAM

2006-09-29 Thread Ranjitha
Hi all, I'm relatively new to python and am facing a problem with database access I want to store my data in a database on the disk. I also want to be able to reload the tables into the RAM whenever I have a lot of disk accesses and commit the changes back to the database. There is an option of s