Subject | IBOQuery used over a VPN very slow |
---|---|
Author | Michael L. Horne |
Post date | 2006-03-21T16:14:53Z |
Hello,
I just tried to run my program over a VPN, it worked fine
until I attempted us open a TIBOQuery. At that time it
paused for about 2 minutes.
I opened the SQLMonitor and looked at what was going on
and it appears that when I am assigning the first
ParamByName, IBObjects pulls from the database all
the table and stored procedure names, then all the
field names, and other stuff.
Why? - and is there a way to disable or lessen the
amount of this information pulled?
I am using a TIBOQuery because I still use QuickReports
for some Report generation.
Thanks
Michael L. Horne
I just tried to run my program over a VPN, it worked fine
until I attempted us open a TIBOQuery. At that time it
paused for about 2 minutes.
I opened the SQLMonitor and looked at what was going on
and it appears that when I am assigning the first
ParamByName, IBObjects pulls from the database all
the table and stored procedure names, then all the
field names, and other stuff.
Why? - and is there a way to disable or lessen the
amount of this information pulled?
I am using a TIBOQuery because I still use QuickReports
for some Report generation.
Thanks
Michael L. Horne