Neven,<div><br></div><div>Most of our work is day-to-day real time dataentry related stuff so not huge volume in the grand scheme. Plenty of reads per day with reporting but not a heavy write. </div><div><br></div><div>I wouldn't know exactly but only a few hundred transactions a day for many, comprising no more than a couple thousand rows of data a day. </div>
<div><br></div><div>MS SQL Server 2005. </div><div><br></div><div>Every now and then we do some re-importing of data, or rebuilds where we are dumping up to 1million transactions (500mb database) and it would take about 1-2hours to write them all out and commit them.</div>
<div><br></div><div>dont know if thats much use to you<br><br><div class="gmail_quote">On Tue, Mar 9, 2010 at 7:59 AM, Neven MacEwan <span dir="ltr"><<a href="mailto:neven@mwk.co.nz">neven@mwk.co.nz</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Hi All<br>
<br>
I'm after some anecdotal numbers,<br>
<br>
1. What is the greatestest number of trans that you have processed daily<br>
into an SQL database<br>
2. What database was it<br>
3. How many rows did the biggest table have<br>
<br>
TIA<br>
Neven<br>
_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe<br>
</blockquote></div><br><br clear="all"><br>-- <br>Kyley Harris<br>Harris Software<br>+64-21-671-821<br>
</div>