ASP response time: db calc vs. ASP calc

[tothemax]

I am working on a project using ASP to store data in a database. In this, the user will answer questions on a webpage and get a response depending on what they enter. There is a calculation needed i.e. case A multiply by x or Case B multiply by y, etc. Which would give better resonse time? To use the database to do the calculation or use ASP coding on the webpage?

Thanks for your help. This is my first time at this and have no experience to base it on.

 

[ChrisHirst]

Tarwn is probably the best person to answer, it's possibly something he will have benchmarked at some time, but my reaction would be that it would depend on where the data is. If it's fields that you are retrieving then SQL would be the way to go but if it's ASP collected data as variables then ASP may well be quicker. Differences are probably marginal and would also depend on the SQL server you are using (MS SQL, Oracle, MySql)
" All SQL servers are created equal, but some are more equal than others. " to paraphrase George Orwell



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[baddos]

A stored proceedure might be faster, but probably isn't work the hastle. Generally data transformation will take place in asp vs. sql server.

 

[tothemax]

Thanks. The data is collected in variables by ASP first then stored to the database. So it appears I am on the right track then by using ASP to make the calculation. Thanks again!

 

[Tarwn]

This isn't something I have actually benchmarked in the past, simplybecause tere isn't a clearcut answer. Depending on which database type your connecting to, etc it could change. In the grand scheme of things neither way is going to take a measurable aount of time, so the difference between the two methods will be even smaller. In this case I would say do what makes you feel the most comfortable from a maintenance standpoint

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
Need an expensive ASP developer in the North Carolina area? Feel free to let me know.