That is exactly right. There were load balancing options and other performance features that were removed from the code to simplify the contribution.
Drew ________________________________________ From: Scott Golightly [[email protected]] Sent: Wednesday, April 22, 2009 6:14 AM To: [email protected] Subject: RE: Why there is so much data in StockTraderDB I believe the large number of records is an artifact of the original purpose of the StockTrader application which was as a performance benchmark. The scripts to test performance would randomly choose an account to buy or sell stock or check the current holdings. Having a large number of accounts to choose from means that the tests can run for hours or days before there is enough additional data in any account to cause the database to be the bottleneck in the system. If we don't see this application being used for performance testing (and I don't) then I don't see a problem with reducing the number of accounts to something more reasonable like 50 and only keeping the data in the other tables that directly relates to those accounts. Scott Golightly -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chintana Wilamuna Sent: Wednesday, April 22, 2009 4:07 AM To: [email protected] Subject: Why there is so much data in StockTraderDB Hi, In my StockTraderDB in SQL Server following are the number of records for each table, account - 1500 accountprofile - 1500 holding - 7500 orders - 7500 quote - 2002 A quick glance through any date stamp column will reveal that it's populated with a script. Why is so much records in the tables? Are they used for anything? If it's not used, I suggest that we get rid of the extraneous records. Thoughts? Bye, -Chintana -- http://engwar.com/
