H2 databases become very slow when using the filesystem instead of in-memory. It might work in small tests but it does not scale well at all.
-Sean ________________________________________ From: Marlon Pierce [[email protected]] Sent: Tuesday, November 08, 2011 12:28 PM To: [email protected] Subject: Small proposed default db setting change -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I propose that we change both the shindig and rave-portal DB connections to jdbc:h2:~/portal_data;AUTO_SERVER=TRUE instead of using the in-memory database. This will allow both rave-shindig and rave-portal to use the same DB instance (http://www.h2database.com/html/features.html#auto_mixed_mode). Seems to work fine in my tests. Marlon -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iQEcBAEBAgAGBQJOuWayAAoJEOEgD2XReDo5GxIIAJQ6X/CEcOSg45nDx5W9gYnS JlI/NO5DvN+G0yKTYKmxwNm1IgE4TG2Qz/6xWEpcW7Np0pZf3ezZy72p+rpwsncc +Fxr7y8oHsvcPmryYEP4uZ86n78hw/8DATR+iPB/AVU39ImzAtSsk5p7zRKFK44e Mx7wUp/1LSwNYyJ5VT826E+8hCsPvKeIWJoCWgkW9JPYpLYe6so69hVVYsQ/Oyvm wJTUpCrKMDSS1vyhSbhOh7xBwXq6gL68WAzLg844mcmNP1jj+4pKJyiqJmYfhNKK orFHZWYDhRkx2Cjviw6lnvNqZz+AFyaCLAfpncDAd7dgSI04xsXQuJNNRqCYE5U= =fmnf -----END PGP SIGNATURE-----
