|
Hi all,
I have a question about the performance of FIND function compared to the SELECT statement. I am developing a VC++ program that queries data from 60+ tables. Before today, I had used only 300 recordsets in the main table and didn't see any problem. Today I added 7000 entries to it, and the a dialog that queries 10 tables (including the main table) took almost 2 seconds to show the result! I use FindFirst/FindNext on all the queries.
Will converting Find to SELECT/WHERE statement help a lot here?
My spec: SQL Express 2005, Pentium4D, 1GB RAM.
Any comments will be appreciated here. Thanks in advance.
|
|
|
|
|
Changing would probably help, but since you are under two seconds the difference would be negligible IMO.
_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.
|
|
|
|
|
But this is under 2secs for entries<10K. I am expecting this to grow close to 1 million, wouldn't the delay grow even more then?
|
|
|
|
|
Ofcourse it will grow. Just use the Select/Where method. But you should have the right indexes! This way you can query a table with bilions of records with a 2 second response time.
But I do not know what kind of application you are talking about. Maybey it is wise to combine the two techniques.
Wout Louwers
|
|
|
|
|
yes, indexing and normalizing your tables will really help.
_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.
|
|
|
|
|
My data is normalized, that's why i have 60+ table for a relatively simple inventory management database.
And if by indexing you mean having Primary Keys, then I have those on the tables that need them.
|
|
|
|
|
Indexing does not mean having Primary Keys. Indexing means creating the right indexes for the queries you perform on the tables.
Wout Louwers
|
|
|
|
|
Hi
Ive got a program that connects and converts an excel file into a plain text file
The problem is that this program works fine on certain pc’s
But on other pc’s it give the following message
Object invalid or no longer set
The strange thing is that this source code has been working fine for years
Pls help
im a junior developer at a company called securemail in south africa
|
|
|
|
|
You need to move this question to the VB message board. Please also include your source code.
_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.
|
|
|
|
|
Hi,
Programatically, I want to creat table space on remote oracle server, but don't know which path should i provide for data file, is there any one can help?
Warm Regards,
Mushq
|
|
|
|
|
Hi Friends,
I want to know is there any way i can use SQL profiler to MONITOR all queries RUN on a PARTICULAR table. I see that there is a way to tracks all queries run a particular DATABASE, but i couldn't find a way to trace queries run on a PARTICULAR table in a database.
Even though there is no direct way a Work around suggestion would be great.
Thanks a lot for ur help..
Regards,
Leela Krishna
|
|
|
|
|
Set a filter on the TextData to be Like %table%.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi Pete,
Thanks a lot.. Will try that..
Regards,
Leela Krishna
|
|
|
|
|
Hi all,
What is the query to get the details of an employee whose sal is the second highest salary among all the epmloyees from Employee table by using SQL Server and Oracle. Thank you.
Regards,
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
This is the type of query that you should be looking at.
SELECT TOP 1 * FROM Employee a WHERE a.Salary IN (
SELECT TOP 2 b.Salary FROM Employee b
ORDER By b.Salary DESC )
ORDER BY a.Salary ASC
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hey man this will work for both sql server and oracle
This is 100% pure SQL
select max(salary) from employee
where salary<(select max(salary) from employee)
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
|
|
|
|
|
Hi guys, I just installed SQL Server 2005, I was wondering whats the diffrence between this and SQL Server 2000.
By the way I've created a database and i want to creat a DataBase Diagram but I can't seem to find the option, I mean its not available !
can you help me out PLZ.
Mr.K
|
|
|
|
|
There are so many differences that it's hard to know where to start. Integrated Reporting Services. BI built into from the start. New T-SQL commands. Common Table Expressions. CLR integrated into Sql Server to allow you to have .NET stored procedures. VARCHAR(MAX). These are all areas that you should take a look at.
Did you install a new instance of the SQL Server engine or did the install perform an upgrade of a 2000 database? If it was the upgrade, then you cannot do anything with database diagrams and the new features will not be available.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Well I downloaded Microsoft Sql server 2005 express edition from Microsoft website ! maybe thats why ! Is there anywhere I can download the full version for free  !!!
Mr.K
|
|
|
|
|
You can find LOTS of articles online that explain the differences.
_________________________________________________________________
Dick Cheney looks like a high school calculus teacher with persistent heartburn.
|
|
|
|
|
Hi
I am trying to create a package programmatically. Transfering 100 or 1000 data no problem if i try to transfer millions of records it is taking more time. If i try the same through intergration project it takes only few minutes.
Any one can help me to speed up the transformation please......
kesavan
|
|
|
|
|
I have this query which I used to populated a dropdown list when a department is assigned to a employee.now I want to populated those department which are not assigned to employee.this query not work.
"select Dep.Department_Name,emp.dept_id from contact_dept
Dep,Contact_Employee_Depts Emp where dep.active=-1 and dep.Dept_id <>
Emp.Dept_Id and Emp.Emp_id=" & CLng(ViewState("Emp_id")) & ";""
Plz Its Urgant
|
|
|
|
|
I think that this is what you want:
select Dep.Department_Name
from contact_dept Dep
where Dep.Dept_id not in (select Emp.Dept_Id from Contact_Employee_Depts Emp where Emp.Emp_id = 123)
and Dep.active = -1
order by Dep.Department_Name Regards
Andy
|
|
|
|
|
|
In sql server 2000 how to find wheather a trigger is enabled or disabled for a particular table...
I found that there is stored procedure sp_helptrigger tablename for getting the details of how many triggers present in a particular table...
But i want to find out find wheather a trigger is enabled or disabled for a particular table...
plz help me out
this is smjp
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)