cost of select query
I am using several select statements but one single table in a stored procedure. But this procedure will run over a million records. So that means the select statements will run over several million records. Can this hamper the speed of my engine?
PS. I am newbee.. as you can see its my first post here
Welcome to DevX
A very general answer to a very general question is it could possibly hamper the speed.
Given your needs, (and I don't know what they are), can you see other ways of doing what you are doing?
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
By jribbe101 in forum Database
Last Post: 12-20-2007, 02:12 PM
By peljo in forum Database
Last Post: 12-17-2007, 12:38 PM
By lightningtechie in forum Database
Last Post: 02-07-2006, 09:34 AM
By Nancy in forum Database
Last Post: 01-11-2002, 10:38 PM
By Mohan Ekambaram in forum Database
Last Post: 12-09-2001, 12:56 PM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL