Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
btrimpop
Posting Yak Master
214 Posts |
 Posted - 2001-02-02 : 08:55:51
|
| The company I work for is building a Web app using a ColdFusion server accessing MSSQL 7.0 databases. The app is going to have to do some serious processing on the data. The question has arisen as to the best approach to take to do this processing. Do the processing on the DB server with stored procedures or off load the processing to ???? (an app server of somekind) and the write the data back once it's crunched. Any suggestions as to the best approach? The amount of time the processing takes is a big consideration and the volume of data is going to be very large after time.And here's some more info on the subject...It's a medical billing package. It takes staff time sheets and turns them into medical insurance bills. Estimates put the monthly volumne at 50,000 or more time sheets a mounth creating 100,000 to 150,000 charges to insurance companies a month, of course keeping track of all historical data for staff productivity and revenue reporting and statistics as well as treatment affectiveness etc. Figure there will be 1/2 to 1 million time sheets a year and at least triple that for charges/payments/adjustments/etc. transactions. With 7 to 10 years of data online.Management will want up-to-date numbers on any and all info in the db so, yes it will be heavily queried. Lots of inserts and updates from data entry people and of course processing. Currently the app is Windows based written in Delphi and I've written all the processing using stored procedures. Currently processing 15000 time sheets takes about 20 minutes. The powers that be want to move the app to the Web. The Dev team leader questions whether stored procs are the best way to do the processing (I've got about 140 stored procs in total).The db servers are going to be minimum dual pentium 700's or better, 2 gig of memory, raid 5 disk subsystems.Whew!!! So what do you think? Thanks in advance |
|
|
|
|
|
How to process data, revisited....