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, 01:12 PM
By peljo in forum Database
Last Post: 12-17-2007, 11:38 AM
By lightningtechie in forum Database
Last Post: 02-07-2006, 08:34 AM
By Nancy in forum Database
Last Post: 01-11-2002, 09:38 PM
By Mohan Ekambaram in forum Database
Last Post: 12-09-2001, 11:56 AM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center