Hello! On Friday 27 February 2009 23:57:39 Allan Edwards wrote: > You setup 2 seperate machines, sqlite on one, and Oracle on another... > they both have the exact make and model hard drives and OS. Which one > can write data faster to the hard drive?
There are two strategies: 1. Rows are writing in realtime. Oracle is faster because using internal write buffers and buffers doesn't really flushing to disk immediately. 2. Rows are writing in batch mode. For example exactly 1 write transaction (with dirrerent count of rows) per second. SQLite is faster because don't have internal write buffers and doesn't write some log files and jornals. But SQLite index creating performance is not very good and using a lot of indexes may provide problems. A lot of realtime write operations (in financials and like applications) are not possible by SQLite (auto-commit mode has bad performance becouse each operation must be flushed to disk). And read SQLite performance can be more better then Oracle because SQLIte dosn't have multy-version control for rows and doesn't have client-server interprocessing overhead but can perform a lot of parallels readings in different threads. Best regards. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
