Yes it is all on one box. It's for this company if your interested. http://www.creditassist.co.uk/
It's a big system that contains all the data form experian and companies house, allos you to do credit checks on companies and company directors. We found that we couldn't use the full-text search or verity though as it was just too slow, and we had to write out own custom solution. But that's mainly due to the fact that we were working with wildcard searches on text fields, and the primary keys were also varchars. So the indexing was pants. Russ > -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > Sent: 13 July 2004 17:00 > To: [EMAIL PROTECTED] > Subject: FW: [ cf-dev ] OT:large (300M+) SQL server installation > > > Thanks for the reply, we are basically trying to access if > SQL server is up to the job, > > Is this 100 million all on one box? > > Kola > > > >> -----Original Message----- > >> From: Snake Hollywood [mailto:[EMAIL PROTECTED] > >> Sent: 13 July 2004 16:57 > >> To: [EMAIL PROTECTED] > >> Subject: RE: [ cf-dev ] OT:large (300M+) SQL server installation > >> > >> Actually just checked, we have about 100 million ish rows in the > whole > >> database, so it is quite big. > >> > >> > -----Original Message----- > >> > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > >> > Sent: 13 July 2004 16:54 > >> > To: [EMAIL PROTECTED] > >> > Subject: RE: [ cf-dev ] OT:large (300M+) SQL server installation > >> > > >> > We have done several million (19gb database I believe), but no > >> > where near 300 million, that's a lot. > >> > > >> > > -----Original Message----- > >> > > From: Kola Oyedeji [mailto:[EMAIL PROTECTED] > >> > > Sent: 13 July 2004 16:46 > >> > > To: [EMAIL PROTECTED] > >> > > Subject: [ cf-dev ] OT:large (300M+) SQL server installation > >> > > > >> > > > >> > > Apologies for the OT post but this is where all the real gurus > hang > >> > > out right ;-) > >> > > > >> > > Does anyone have any experience with large scale SQL server > >> > > installations - 300Million rows+ if so could you contact me > >> > off list? > >> > > > >> > > Thanks > >> > > > >> > > Kola Oyedeji > >> > > Certified Advanced Coldfusion Developer, ICLP London > >> > > DDI: +44 (0) 208 256 9034 (Ex.2204) > >> > > > >> > > www.iclployalty.com > >> > > > >> > > > >> > > > >> > > > >> > > -- > >> > > These lists are syncronised with the CFDeveloper forum at > >> > > http://forum.cfdeveloper.co.uk/ > >> > > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > > > >> > > CFDeveloper Sponsors and contributors:- *Hosting and > >> > support provided > >> > > by CFMXhosting.co.uk* :: > >> > > *ActivePDF provided by activepdf.com* > >> > > *Forums provided by fusetalk.com* :: > *ProWorkFlow provided > by > >> > > proworkflow.com* > >> > > *Tutorials provided by helmguru.com* :: > *Lists hosted > by > >> > > gradwell.com* > >> > > > >> > > To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > > > >> > > >> > > >> > -- > >> > These lists are syncronised with the CFDeveloper forum at > >> > http://forum.cfdeveloper.co.uk/ > >> > Archive: > http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > > >> > CFDeveloper Sponsors and contributors:- *Hosting and support > >> > provided by CFMXhosting.co.uk* :: > >> > *ActivePDF provided by activepdf.com* > >> > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by > >> > proworkflow.com* > >> > *Tutorials provided by helmguru.com* :: > *Lists hosted by > >> > gradwell.com* > >> > > >> > To unsubscribe, e-mail: [EMAIL PROTECTED] > >> > > >> > >> > >> -- > >> These lists are syncronised with the CFDeveloper forum at > >> http://forum.cfdeveloper.co.uk/ > >> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > >> > >> CFDeveloper Sponsors and contributors:- *Hosting and > support provided > >> by CFMXhosting.co.uk* :: *ActivePDF > provided by > >> activepdf.com* > >> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by > >> proworkflow.com* > >> *Tutorials provided by helmguru.com* :: *Lists hosted by > gradwell.com* > >> > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > -- > These lists are syncronised with the CFDeveloper forum at > http://forum.cfdeveloper.co.uk/ > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > CFDeveloper Sponsors and contributors:- > *Hosting and support provided by CFMXhosting.co.uk* :: > *ActivePDF provided by activepdf.com* > *Forums provided by fusetalk.com* :: *ProWorkFlow > provided by proworkflow.com* > *Tutorials provided by helmguru.com* :: *Lists > hosted by gradwell.com* > > To unsubscribe, e-mail: [EMAIL PROTECTED] > -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
