Hi. Pardon my ignorance, but I need some help with the following :
I'm tasked with selecting the hardware for a new web development, but my experience mostly lies with MSSQL Server, and not MySQL or PostgreSQL. The scenario is a web application, Java-based, of course, on Glassfish 2.1, using either PostgreSQL or MySQL. I'm leaning towards PostgreSQL, although I'm sure there are MySQL advocates out there that will have a different opinion. The debate is not about the database though, but about the server requirements. We will be experiencing about 1000 concurrent users, tables (not complex) in excess of 20 million records each, and of course, a ton of business logic in the back end. I've no clue what kind of hardware / OS to specify, although I'm betting a *NIX operating system will be preferred, to keep initial costs down and also to allow us to use multiple processors and Gigs of RAM without additional licenses being required. The primary concern that we have, is speed. In our humble experience, SQL starts getting slow with huge numbers of records, and this database will be growing, fast. Which OS would allow us the simplest clustering capability and still be easy enough to learn within a very short time-frame ? Thank you Ewald Horn --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CTJUG Tech" 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/CTJUG-Tech?hl=en For Cape Town Java User Group home page see http://www.ctjug.org.za/ For jobs see http://gamatamjobs.appspot.com/ -~----------~----~----~----~------~----~------~--~---
