Yes, those are definitely some hefty requirements, and if there requirement is to access with some kind of direct hashing algorithm that a NoSQL database offers would be more cost-effective...
-Owen On Tue, Dec 21, 2010 at 11:44 AM, Henry Baragar < [email protected]> wrote: > Owen, > > I don't have all the details yet, but it would be an Internet-based case > management system that can handle: > > - >10M clients > - 20-100 MB/client of reports and images (close to 1 PB of data) > - data for one client completely unrelated to another > - 100K requests per hour, with an average size of 2MB and a response > time of less than 5 seconds > > And, these estimates could be out by a factor of 10 (either way). > > Currently they don't have these volumes, so they need a strategy to scale > up to the anticipated volumes. > > It may be that a relational database can handle these volumes, but from > what I have learned, from an administrative & performance tuning > perspective, mongoDB would be much better in this situation. These > requiremenst need to be balanced off against the development effort. > > Henry > > On December 21, 2010 07:39:57 am Owen wrote: > > > Henry, > > > > > > Can you share what write/read volume and user capacity that your client > > > thinks won't scale with a relational database? > > > > > > Perhaps that may be an issue with MySQL, but Oracle can scale (but you pa > > > $) and Postgres (free) has a great reputation, but haven't tried it > > > myself. > > > > > > -Owen > > > -- > > Henry Baragar > > Instantiated Software > > -- > You received this message because you are subscribed to the Google Groups > "Hobo Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<hobousers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/hobousers?hl=en. > -- - Owen Owen Dall, Chief Systems Architect Barquin International www.barquin.com Cell: 410-991-0811 -- You received this message because you are subscribed to the Google Groups "Hobo Users" 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/hobousers?hl=en.
