and .. but on the advantage side of sqllite i have to admit it is easier to switch hardware by just having the opensim.db on a memory stick ... much better than having the sql dump and to install mysql and setting it up. For beginners sqllite is much more comfortable .. (or you use the No-install version 4 of mysql )
also if you 'keep' several version of your sims in different build stages, and therefore in different folders on your harddisk it is more flexible .. (depending on your database experience level) i can also recommend a firefox extension called sqlite-manager where you can have a look into the .db file or mayby change all your landradio streams to the same station by pasting the Stream Url to the .db fields .. or you can remove the " your parcel " info on all sims without visiting them after mayby a load oar :-) https://addons.mozilla.org/en-US/firefox/addon/5817 regards -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Wordfromthe Wise Gesendet: Dienstag, 7. Juli 2009 00:00 An: [email protected] Betreff: Re: [Opensim-users] SQLite vs MySQL - any big difference? i also see faster startup times on my standalones. And also visible faster rezzing of prims inworld .. and here is a test with one of my sims .. bit done by the "landlord" ... http://www.maxping.org/resources/how-to/maintain-regions/moving-a-sim-from-s qlite-to-mysql.aspx best regards Wordfromthe Wise -----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von Chris Hart Gesendet: Montag, 6. Juli 2009 23:07 An: [email protected] Betreff: Re: [Opensim-users] SQLite vs MySQL - any big difference? MSSQL works very well too (and Express edition is free for databases up to 4Gb). While it's not officially supported by core devs to the same extent as MySQL, those of us who use it are avid patchers and keep the MSSQL side up-to-date. As far as OpenSim is concerned, you can use it for standalone, but SQLite is extremely simple out of the box for a basic standalone. It's a solid alternative to MySQL. Chris -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tim Allen Sent: 06 July 2009 21:26 To: [email protected] Subject: Re: [Opensim-users] SQLite vs MySQL - any big difference? It is funny to see MySQL being described as the more robust solution, when some (very uninformed) people still call it a 'toy database' - which was sort of true in 1999, but not 2009. In 2009, MySQL is an extremely robust, high-performance, high-reliability database that scales quite nicely. I'd highly recommend it over SQLite for any kind of reliability, but as mentioned before, for single-user sandboxes, SQLite may be easier out of the box. _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users Checked by AVG - www.avg.com Version: 8.5.375 / Virus Database: 270.12.94/2208 - Release Date: 07/05/09 17:54:00 _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users _______________________________________________ Opensim-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-users
