Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    26

    Unanswered: oracle table retrieval speed

    I have convert Ms access database to oracle database and still using ms access as dev tool. but i could not get the same speed like MS access thru network. for example the simplest retrival is open a linked table of 200000 records, the time consumed to show all records from oracle table in client terminal is 3 times than it takes by ms access table thru network
    is there any way to take the same response time or better
    thanks in advance

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >is there any way to take the same response time or better
    Yes. In the initSID.ora file set the following parameter
    _make_oracle_faster=TRUE

    Of course this is DB & OS version dependent , which you neglected to specify.

    What is the table description?
    What is the actual SQL used as comparision?
    Are there any indexes on the table?
    Are statistics current for the table?
    What is the speed comparision if you used SQL*Plus instead of ACCESS?

    HTH & YMMV
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jul 2004
    Posts
    26
    thanks for ur fast reply,

    sorry 4 being not very specific

    i'm using oracle 9i on windows 2003 server

    ur other questions i'm still not familiar with
    if u can just help me give u more details

    and if there anyone who is working with access-oracle I appreciate his help

    thanks in advance

  4. #4
    Join Date
    Jan 2004
    Posts
    492
    Quote Originally Posted by anacedent
    >Yes. In the initSID.ora file set the following parameter
    _make_oracle_faster=TRUE
    Oh I think I have been missing this from my own Oracle installation - makes sense now..lol

    Anywho -

    1) Table description = Columns, datatypes (ie number, varchar2..etc) of tables used in the queries

    2) Post your code - we can't guess why your code isnt working if no code is provided.

    3) Indexes can be placed on the tables to speed retrieval - are they any?

    4) Run explain plan...etc to find out where your time is being spent.

    5) Run your query through SQL*PLUS - Oracle's front end. Compare that to running the query through Access - is there any time difference?
    Oracle OCPI (Certified Practicing Idiot)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •