<div>kirby my answers below,</div>
<div> </div>
<div>1) When you say 50 users .. Is that 50 users on-line concurrently? If not<br>... How many concurrent users?<br> </div>
<div>The client told us 50 concurrent.</div>
<div> </div>
<div>2) How large is the database? A 10GB database is much easier to run than a<br>100GB one or 1TB.</div>
<div> </div>
<div>no estimate is available, application is starting from zero. So I guess it will grow quite large since the customer is a dealer of very very small parts (bolts, spark plugs, nuts,etc) and many pictures.</div>
<div><br>BTW: What I am seeking is some guides as to how to improve the Linux part of performance.</div>
<div>Are there any TPC-C (free or open source, maintanied if possible) software that i can use?</div>
<div> </div>
<div>I will read these two posts that seem very interesting</div>
<div> </div>
<div><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.puschitz.com/OracleOnLinux.shtml" target="_blank">http://www.puschitz.com/OracleOnLinux.shtml</a> (provided by greg knaddison)</div>
<div><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://www.linuxjournal.com/article/5840" target="_blank"><font size="2">http://www.linuxjournal.com/article/5840</font></a> (provided by Dan elliott)</div>
<div><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://puschitz.com/" target="_blank"><font size="2">puschitz.com</font></a></div>
<div> </div>
<div> </div>
<div>Thanks to all.<br><br> </div>
<div><span class="gmail_quote">On 6/26/05, <b class="gmail_sendername">kirby</b> <<a href="mailto:kirby@igalaxy.net">kirby@igalaxy.net</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Erick,<br><br>At first glance that system is undersized. This depends heavily on your<br>application for a very 'light' application this might be fine.
<br><br>CPU seems slightly low, but might be okay.<br>RAM is low. Putting 4GB in there would likely seem you some improvement as<br>more data can be loaded in RAM rather than disk<br>Disk is likely fine if most of what you are doing is read intensive.
<br><br>As a baseline I recently set-up a 110 user (maybe 20 active at a time)<br>OLTP/Data Warehouse Hybrid with 12 GB RAM running on Windows 2003. The<br>entire database was approx 70GB in size (30GB was a tempfile because of some
<br>poor SQL code) CPU was 2 3.2GHz P4's. It was a client/server based<br>architecture.<br><br>1) When you say 50 users .. Is that 50 users on-line concurrently? If not<br>... How many concurrent users?<br>2) How large is the database? A 10GB database is much easier to run than a
<br>100GB one or 1TB.<br>3) What kind of processing are they doing? Simple OLTP or heavy reporting?<br><br>Good luck,<br>Steve<br><br></blockquote></div><br><br><br>-- <br><br>-------------------------------------------<br>
Erick Perez<br>Linux User 376588<br><a href="http://counter.li.org/">http://counter.li.org/</a> (Get counted!!!)<br>Panama, Republic of Panama<br>