samcfug wrote: > > But, I wonder just how many database servers host VLS (very large scale) > databases? I imagine the vast majority are much smaller.
Is 20 GB very large scale? In that case, I know quite a few (although all on a dedicated server [1]). > Getting into databases that large, brings one into the arena of fiber > channel connections, and other technology to increase speed and processing > power. (Thinking of the terradata.microsoft.com deal) I think that is more something for the TB range. Would be cool to play with :) > Then again, queries that are sloppily written can also place loads on a > system that will bottleneck the data retrieval process on any system, > regardless of configuration, right? Yes. Sloppy architecture, writing and maintenance are usually the most important problems. [1] Once I made a typo in a query which resulted in 1200 times half a million affected record instead of 1200 times 1 affected record, which if left alone would have gotten at least 60 GB + transaction log. Would that qualify as over 20 GB on a non-dedicated server? Jochem ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
