What is the difference between the embedded database and the server database?
>From my point I need to have up to 50 users accessing the data from a webpage using the OpenBD (.cfm) pages. I have 9 tables that hold a small amount of data. One table holds a list of doctors, one holds a list of rooms and one holds a list of patients being seen today etc. At the end of the day I clear the table that holds the patients and I am only left with the same data from the day before...admin stuff in the tables. I looked at all of out Sql Server tables for all of our applications and we have under 1 g of data stored and about 120 users accessing this data on a daily basis. It is small but used very frequently during the day. I can give you more details on the applications if you like. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Woodward Sent: Tuesday, November 25, 2008 11:13 AM To: [email protected] Subject: [OpenBD] Re: Installing and Running OpenBD Augusta ENT wrote: > I would normally wait for the final product but we want to test on our app > with OpenBD and H2 while we have time. We have time this > week so we want our proof of concept tested complete so we are ready to roll > out our product to a customer the first week in > December. > > We were going to use SQL Server but if H2 works like we think it will then > our customer will save $5k! > > > Are you using H2 as an embedded database or as a traditional database server? What will be rolled into the admin console is H2 embedded, but the driver and basic JDBC URL should be similar. I didn't look into using H2 as a server (focused on embedded) but I can likely add that if that's the way you use it. -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com/blog Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Open BlueDragon" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/openbd?hl=en -~----------~----~----~----~------~----~------~--~---
