Database & SQL

Moderators: None (Apply to moderate this forum)
Number of threads: 1194
Number of posts: 2247

Database & SQL
Subforums
Forum Info
This Forum Only
Post New Thread
Single Post View       Linear View       Threaded View      f

Report
Query optimization Posted by tejal_k_mehta on 27 Oct 2004 at 4:51 AM
Hi,
i have devlope search utitlity in VB application.
in that utillity i have given a option for Search whole database.
but it takes 15 mins for 13000 records to search whole database.

this utility is used for ACCESS ,SQL and ORACLE database.

i want to make search more faster if possible.it possible it should get the result within 5 to 7 mins for 13000 recrods.

Pls help me regrading this.

Thanks in advance.
Reply   Share By Email Share By Email
Thread Tree
tejal_k_mehta Query optimization on 27 Oct 2004 at 4:51 AM
infidel Re: Query optimization on 27 Oct 2004 at 8:05 AM
tejal_k_mehta Re: Query optimization on 27 Oct 2004 at 10:05 PM
infidel Re: Query optimization on 1 Nov 2004 at 8:07 AM



 

Recent Jobs

Home About PH Privacy Statement Hosted SubVersion Hosted Bugtracker Contact Us Advertise Here
Official Programmer's Heaven Blogs
Web Hosting | Browser and Social Games | Gadgets

Popular resources on Programmersheaven.com
Assembly | Basic | C | C# | C++ | Delphi | Flash | Java | JavaScript | Pascal | Perl | PHP | Python | Ruby | Visual Basic
© Copyright 2011 Programmersheaven.com - All rights reserved.
Reproduction in whole or in part, in any form or medium without express written permission is prohibited.
Violators of this policy may be subject to legal action. Please read our Terms Of Use and Privacy Statement for more information.
Operated by CommunityHeaven, a BootstrapLabs company.