Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2006
    Posts
    4

    Question Unanswered: Problem with OpenSchema

    Hi, I have a problem with OpenSchema function in ADO. I work with Oracle database. Every time when i Open Table, Refresh Table, Update IndexDefs and so on, ADO calls OpenSchema and every time OpenSchema executes about 4 - 5 seconds, so when I have 20 tables in the database I wait about 2 minutes for my program to start. Do you have any idea why OpenSchema works so slowly?
    Thanks!

  2. #2
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    And why do you need to use OpenSchema (which I was not aware of until now) at all ?

  3. #3
    Join Date
    Mar 2006
    Posts
    4
    Controls like ADODataSet and ADOConnection use it (I work with delphi). What do you suggest to avoid the usage of "OpenSchema" function

  4. #4
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I dont know actually, I have never worked with ADO on Delphi (thought you were on VB.NET/VB). Perhaps there could be a setting under ADODataSet and ADOConnection controls to disable this behaivour ?

  5. #5
    Join Date
    Mar 2006
    Posts
    4
    I don't think that this function can be disabled because this is a part of the communicaiton between the applicaiton and the database.

    http://www.w3schools.com/ado/met_conn_openschema.asp

  6. #6
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You only need the OpenSchema call if you need to gather information about the current open schema. If you want to access a known table, simply establish a connection, define the recordset and fire the query.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  7. #7
    Join Date
    Mar 2006
    Posts
    4

    Thumbs up

    OK, thanks a lot for the information!

Posting Permissions

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