Query optimization - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Query optimization

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.

Comments

  • infidelinfidel Posts: 2,900Member
    : 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).


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

  • tejal_k_mehtatejal_k_mehta Posts: 23Member
    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).
    :
    :
    : [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]
    :
    : [code]
    : $ select * from users where clue > 0
    : no rows returned
    : [/code]
    :
    :

  • infidelinfidel Posts: 2,900Member
    : 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?


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

Sign In or Register to comment.