Hello! I did migrate two projects from PostgreSQL (one is ~22 Gb database with very complex reports) and now migrate oracle project (>100 Gb billing database with distributed data collectors) for best performance on multi-core servers and SATA disks. SQLite database may be replicated or copied very simple and it's very useful property for distributed projects. I did use SQLite some years on linux servers && windows desktops && linux desktops && winmobile PDA/Smartphones and now I'm know that SQLite is sure remedy and I can eliminate PostgreSQL/Oracle from my projects completely.
My results is up to 60x better performance and more quality C && tcl code and more fast development process. There are some patterns for hight load SQLIte projects development in SQLite Wiki. But successful examples of big projects is more comprehensive knowledge for developers. Thanks for excellent database engine! Best regards, Alexey. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
