Considering Sqlite for Pritlog
After my experiments with flat files and php for Pritlog, when I came to find out that Sqlite would be much more performance effective compared to flat files, I am starting to think if I should move to Sqlite for Pritlog.As an initial test, I tried using a table with 5000 records. Did all common operations like read, update, search. These operations completed in an instant. Absolutely no performance issues. Users would not even realize that there are 5000 records being accessed. I am impressed.
Sqlite databases are simple files created on the path you specify. Hence, I would think, we can move these around and get the same functionality. Mobility is one thing I would like Pritlog to always have.
I have posted on the Pritlog forum to see the responses from about moving to Sqlite.
Tags: programming - Visits: 360 - No Comments