"Evidence" ? Of what? All you can get from asking this sort of question is "samples".
The performance of an RDBMS server is contingent on a huge number of factors. Not least of course is the specification of the hardware and, to an extent, the operating system. Server load is another obvious factor. You may obtain a number of anecdotal samples representing everything from unrealistic throughput benchmarks conducted with zero server load (other than the benchmarking process) through to highly realistic but far less impressive throughput achieved under realistic loads. And even then, the throughput will vary according to the nature of the database (OLTP systems will generally yield lower TPS than "read-only" OLAP data stores given the nature of the "transactions" involved). If you were to explain what the "evidence" you are gathering is intended to establish (or disprove) people may be able to better provide the samples that will help "build your case". :) > -----Original Message----- > From: delphi-boun...@delphi.org.nz [mailto:delphi- > boun...@delphi.org.nz] On Behalf Of Neven MacEwan > Sent: Tuesday, 9 March 2010 9:04 a.m. > To: NZ Borland Developers Group - Delphi List > Subject: Re: [DUG] Skite time > > Edward > > I was just after anecdotal evidence, yes am aware of the differences so > if > anyone wishes to they may incude row size and index count. > > Neven > > > Questions not quite correct... > > > > You can have billions small records in one table and everything will > be > > working fine. > > Opposite situation - table with row with exceeds page size and has a > lot > > of indexes.... > > > > Edward Koryagin > > > > > > --- On Tue, 9/3/10, Neven MacEwan <ne...@mwk.co.nz> wrote: > > > >> From: Neven MacEwan <ne...@mwk.co.nz> > >> Subject: [DUG] Skite time > >> To: "NZ Borland Developers Group - Delphi List" > <delphi@delphi.org.nz> > >> Received: Tuesday, 9 March, 2010, 7:59 AM > >> Hi All > >> > >> I'm after some anecdotal numbers, > >> > >> 1. What is the greatestest number of trans that you have > >> processed daily > >> into an SQL database > >> 2. What database was it > >> 3. How many rows did the biggest table have > >> > >> TIA > >> Neven > >> _______________________________________________ > >> NZ Borland Developers Group - Delphi mailing list > >> Post: delphi@delphi.org.nz > >> Admin: http://delphi.org.nz/mailman/listinfo/delphi > >> Unsubscribe: send an email to delphi-requ...@delphi.org.nz > >> with Subject: unsubscribe > >> > > > > > > > > > > > > _______________________________________________ > > NZ Borland Developers Group - Delphi mailing list > > Post: delphi@delphi.org.nz > > Admin: http://delphi.org.nz/mailman/listinfo/delphi > > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with > Subject: > > unsubscribe > > > > > > > > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: delphi@delphi.org.nz > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to delphi-requ...@delphi.org.nz with > Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to delphi-requ...@delphi.org.nz with Subject: unsubscribe
