Speed check
by Jonathon Stevens · in Torque Game Engine · 01/30/2006 (5:08 pm) · 2 replies
I'm curious as to what scenerio people think would be quicker and why:
Using SQL Statements from code on the server to directly access the database.
Using a web service that the server sends the info too which then calls STORED PROCEDURES in the database and sends the info back to the server.
Obviously stored procs are faster than T-SQL, but adding the step of going through a web service to call the sprocs is where I'm wondering if you'd loose the benefits or not.
Using SQL Statements from code on the server to directly access the database.
Using a web service that the server sends the info too which then calls STORED PROCEDURES in the database and sends the info back to the server.
Obviously stored procs are faster than T-SQL, but adding the step of going through a web service to call the sprocs is where I'm wondering if you'd loose the benefits or not.
About the author
With a few casual games under his belt as CEO of Last Straw Productions, Jonathon created the increasingly popular Indie MMO Game Developers Conference.
Torque Owner Duncan Gray