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.

: 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.

This question is too vague to answer accurately. What do you mean by "search whole database"? Are there multiple tables? Joins? Subqueries? Different databases may require different optimization techniques. You might be able to create indexes that will help (at least in SQLServer and Oracle).


infidel

$ select * from users where clue > 0
no rows returned

Thanks,
Query has Multiple tables. it is like this
Select Tab1.* From tab1,tab2 where Tab1.Fiels1=Tab2.Field1

Search Whole database(i mean search all reacords, by mistake i wrote Search whole datbase) means i need to scan whole table to find out the required one and scaning of whole table takes long time and i want to minimize that time.


: : 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.
:
: This question is too vague to answer accurately. What do you mean by "search whole database"? Are there multiple tables? Joins? Subqueries? Different databases may require different optimization techniques. You might be able to create indexes that will help (at least in SQLServer and Oracle).
:
:
: infidel
:
:

: $ select * from users where clue > 0
: no rows returned
: 

:
:

: Thanks,
: Query has Multiple tables. it is like this
: Select Tab1.* From tab1,tab2 where Tab1.Fiels1=Tab2.Field1
:
: Search Whole database(i mean search all reacords, by mistake i wrote Search whole datbase) means i need to scan whole table to find out the required one and scaning of whole table takes long time and i want to minimize that time.

Are you scanning the rows in your program or are you using a "WHERE" clause in your SQL to make the database do the scan?


infidel

$ select * from users where clue > 0
no rows returned