-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Joanne Pham wrote: > I send this email to the group to ask the question just in case if someone in > group has done the bench mark then it will save my time.
You asked about "SQLite database operation like Read/Write". While technically that eventually happens under the hood, SQLite performance is dominated by your queries, your schema and your database content. And even then performance is also affected by your platform - different operating systems have different performance characteristics. Different storage media and their embedded caches also have different characteristics (SSD, different RPM etc). This has been repeatedly stated in this mailing list. > If I know the result by trying the newer SQLite than I won't ask this > question right? Your question is vague and open ended. You are asking other people to do your work for you, without having done anything yourself. At least read the introduction: http://www.catb.org/~esr/faqs/smart-questions.html Constructively, the question could have been considerably better by giving more information. For example if you mostly do 4 way joins then mentioning that would allow someone to give you a more specific answer. If you have lots of small tables that would be useful. The operating system you use. Any information at all. From your earlier posts it seems like you also use various pragmas to change defaults which would also have an effect, otherwise why change them? They should also have been mentioned. > You don't need to ask me to read the "smart-questions". Actually yes I do since you repeatedly don't ask smart questions which results in them going unanswered, non-answers, or many many followups trying to get at what your question actually is. http://article.gmane.org/gmane.comp.db.sqlite.general/35086 http://article.gmane.org/gmane.comp.db.sqlite.general/46312 > If you don't know the answer to the question please keep quiet. Noone knows the answer since it isn't a good question. And despite what you may be thinking, the readers of this list want your good questions and want to provide good answers. We all want to learn, improve our knowledge of SQLite and make better use of it. If for example you had done some of your own benchmarking and posted the results then that would be interesting, providing there was sufficient information for others to experiment too. For example if you had posted that your performance was dominated by 4 way joins over 10 million row tables and that 3.6.14.2 was 42% faster than 3.5.9 then that is good information and others can help confirm if SQLite really got that much faster, maybe there is a problem on your platform, test methodology, you found a bug etc. So please please please read the smart questions page even if you think you don't need to. Even following a small portion of its advice will result in you getting better answers and the rest of learning from them. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkokkmIACgkQmOOfHg372QQtfACgxt9TABunWsjcMj4Hm/U1o/tu K9sAoKjJUjA6GeSAyXtw4XjpahN1hwqp =8osB -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
