PC Review


Reply
Thread Tools Rate Thread

ADOX performance problem: first attempt to read value from open ADOX catalog lasts long time

 
 
lampi
Guest
Posts: n/a
 
      28th Apr 2005
Why does this function (see below: opening the ADOX catalog and
retrieving number of tables, views and procedures) last that long?


MS Access 2002 SP2
Windows XP
on a P4, database on local harddisk

Thanks for any hints
Bernd


Sub foo()
Dim cADOXcat As ADOX.Catalog
Dim l As Long
Dim t As Long

Set cADOXcat = New ADOX.Catalog
cADOXcat.ActiveConnection = CurrentProject.Connection

Debug.Print "cADOXcat.Tables.Count: ",
t = Timer
l = cADOXcat.Tables.Count
Debug.Print Timer - t; " [s]"
l = cADOXcat.Tables.Count ' 2nd and further accesses fast!

Debug.Print "cADOXcat.Views.Count: ",
t = Timer
l = cADOXcat.Views.Count
Debug.Print Timer - t; " [s]"

Debug.Print "cADOXcat.Procedures.Count: ",
t = Timer
l = cADOXcat.Procedures.Count
Debug.Print Timer - t; " [s]"

' ...

Set cADOXcat = Nothing
End Sub


cADOXcat.Tables.Count: 17,5546875 [s]
cADOXcat.Views.Count: 18,7734375 [s]
cADOXcat.Procedures.Count: 18,7734375 [s]
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADOX catalog tables slow performance ericgj Microsoft Access 16 29th Jan 2009 03:00 AM
getting sheets when using ADOX Catalog to read Excel pietlinden@hotmail.com Microsoft Access External Data 2 1st Nov 2007 10:03 PM
ADOX.Catalog =?Utf-8?B?R3JlZ29yeSBQb3Vsbw==?= Microsoft Access 6 21st Jul 2005 11:26 AM
Problem changing password using ADOX.Catalog.Users(User).ChangePassword Neil Robbins Microsoft Access Security 30 12th Apr 2004 03:24 AM
Help with ADOX.Catalog =?Utf-8?B?TURX?= Microsoft Access VBA Modules 2 7th Apr 2004 02:21 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:08 AM.