At 07:08 06/06/2012, you wrote:
Hi,
I have few queries regarding the SQLite. I have listed them below please go
through them and give your answers. Thanks
Say if I am working on a DB with 3 tables with 100 records each and each
records with some 5 fields of data.Each field is varchar(20)
1. What will be the Stack Size?
Depends on what are you doing with the db, it vary with time.
2. What will be the Heap Size?
Again, depends on what are you doing.
3. What is the max no. of file pointers that will be used at a point of
time?
If I Remember Correctly (IIRC) it's 2 per db file. But it was on
3.2.x times. Keep in mind that sqlite can access and manage up to 32
db files using ATTACH.
4. What is the max no. of Mutexes that will be used at a point of time?
Don't know, why do you need it?
5. Is there a tool to calculate these?
Compile with debug mode on and use gdb.
Please bare my ignorance if any and answer these questions.
Thanks Again,
Raghava Reddy
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
