• 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.

Are you using stored procs and bind variables in your SQL?

S

Shazam

Golden Member
Just curious... With the beating that this forum gets, are you using CFQUERY or stored procedures? How about bind variables to keep an execution path for your SQL within SQL Server?
 
There is barely any different between using stored procs or cfquery, the query times aren't the problem here at all. Its a dead scsi drive and a motherboard or memory issue in the db server. As it will shut itself off once and awhile, and sometimes just crash SQL server. Query speed has absolutely nothing to do with it 🙂
 
Sure, and it will handle it just fine. The db server has some hardware issues that are going to be fixed this week with a new server. You do not need multiple sql servers for this load, maybe in a year or two but not right now. The cost associated with a proper transactional based sql cluster is astronomical.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top