[sqlite] SQLite Optimization

[mr_orange]

I am trying to optimize the speed of my SQLite transactions. The goal is to
beat query and insertion times that we have with MS SQL. I guess there are 2
main issues:

1) The query times are faster when I do simple select statements on a large
amount of data. I start to run into trouble when I get into more complex
join statement that involve date conversion functions. I've read that
replacing joins with WHERE statements that involve consideration of the
ordering of tables in FROM statement can help with speed. However, I am a
little skeptical since I think that this consideration was already made in
the current implementation.

2) I've tried ramping up the cache_size (from 2000 to 1), but I don't
see any effect, even with simple select statements. Does this seem strange?

I've consulted the following site: 
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragma-cache_size
SQLite Optimization 
for advice on how to optimize SQLite. Does anyone know of any other
resources on the topic of optimizing SQLite?

Any advice welcome, thanks.


-- 
View this message in context: 
http://old.nabble.com/SQLite-Optimization-tp26630742p26630742.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Location of Sqlite Files

[mr_orange]

Hey, I am kind of new to SQLite. I was wondering if anyone could help me with
a couple things:
1) Where are the SQLite databases stored? I was told in the C:\WINDOWS\temp
folder, but I can't seem to find any SQLite-related files there.
2) How do you delete a SQLite database?

Any help is much appreciated, thank you.
-- 
View this message in context: 
http://old.nabble.com/Location-of-Sqlite-Files-tp26545375p26545375.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users