MySQL and SQLite
Posted: Wed Aug 01, 2007 10:19 am
SQLite uses files to store databse information and it opens and closes them in order to get that information.
MySQL as far as i know does the same thing except it breaks up the files to become much smaller files and spreads then across. alot of the times each table is it's own file. SQLite does not do that as far as i know. it just puts it all into one file.
if you run SQLite in memory it is faster than MySQL (from thier 2005 speed comparison tests). if you have SQLite work with opening and closing the files then it becomes a much bigger overhead.
i'm just asking to learn more about databases in general and this is a question that i've had. why is it that MySQL can be really fast and SQLite not if they are both opening files? the reason i ask is because i wanted to use SQLite for databases but the application that i'm going to use could become gigantic and keeping all that in memory would not work out as well as i would like.
thank you for your responses
MySQL as far as i know does the same thing except it breaks up the files to become much smaller files and spreads then across. alot of the times each table is it's own file. SQLite does not do that as far as i know. it just puts it all into one file.
if you run SQLite in memory it is faster than MySQL (from thier 2005 speed comparison tests). if you have SQLite work with opening and closing the files then it becomes a much bigger overhead.
i'm just asking to learn more about databases in general and this is a question that i've had. why is it that MySQL can be really fast and SQLite not if they are both opening files? the reason i ask is because i wanted to use SQLite for databases but the application that i'm going to use could become gigantic and keeping all that in memory would not work out as well as i would like.
thank you for your responses