• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

eCommerce database connection question

1

10Strip

Junior Member
OK, ASP with backend COM ponents. Where should I be running my queries and stored procedures from, inside the COM or directly from the ASP?
 
Well... it is a double edged sword.

COM is compiled code... which is nice and runs fast...

However... you have to make that damn Server.CreateObject call which could kill the performance gain you get from compiled code, especially if the COM you are calling has a ton of other stuff BESIDES just the interface for the DB query.

I would say put the DB queries in the ASP... translating ASP isn't too bad, and I would only put really computational intensive stuff in a compiled COM... like some sort of statistical analysis. So put the query in the DB as a stored procedure, and call it up from ASP. Basically, the stored procedure won't run any faster if it is called from COM or not. So stick with ASP.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top