dean wrote:
> On Jul 27, 6:05 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> dean wrote:
>>> On Jul 27, 11:26 am, DA Morgan <damor..._at_psoug.org> wrote:
>>>> dean wrote:
>>>>> Hello all,
>>>>> We are attempting to improve performance of a Windows app that
>>>>> performs a fair amount of networking, loading up grids and tables,
>>>>> opening data sources, etc. The database resides in Calgary, Canada,
>>>>> while the app is based in Toronto, 2000 miles away. The responsiveness
>>>>> of the app is not sooooo bad, one can scroll between rows of a
>>>>> databound grid at 1 per second, but generally it needs to be sped up
>>>>> or we'll have to go to some kind of remote access system and put the
>>>>> app next to the server.
>>>>> So, I have two questions on if and how this process could be sped up:
>>>>> 1. Until now we have used the MS driver for Oracle, instead of the
>>>>> Oracle driver for Oracle, since there were some issues with the oracle
>>>>> driver. Over long distance, is there any advantage of using the Oracle
>>>>> driver over the microsoft?
>>>>> 2. Either way, are there any parameters in the driver settings (such
>>>>> as buffer size), that would be worth investigating for speed
>>>>> improvement?
>>>>> We are using 10g 10.2.0.2.0, and the client uses ADO from a Borland
>>>>> app on Windows XP.
>>>>> Thanks for any suggeestions.
>>>>> Dean
>>>> Database version?
>>>> What tool was used to create the front-end?
>>>> Are records cached on the client? If not why not?
>>>> The rule of thumb for delay is 1ms/33 miles so any delay significantly
>>>> in excess of 60ms is an issue.
>>>> --
>>>> Daniel A. Morgan
>>>> University of Washington
>>>> damor..._at_x.washington.edu (replace x with u to respond)
>>>> Puget Sound Oracle Users Groupwww.psoug.org-Hide quoted text -
>>>> - Show quoted text -
>>> All data loaded into databound components (such as grids) are cached,
>>> I believe. The CacheSize parameter in the data components (TADOQuery)
>>> is set to 100 to 10,000 in various different components.
>>> Version is mentioned above - 10.2.0.2.0
>>> Used Borland CBuilder 6
>> If you are caching 100 to 10K records and have the delay you reported
>> something is seriously wrong.
>> --
>> Daniel A. Morgan
>> University of Washington
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>>
>> - Show quoted text -
>
> Wouldn't that depend on how many tables and records are opened and/or
> loaded into memory? I will take a look and try to guess how many there
> are and post here, but I know its a fair amount of data.
Not if you are caching a result set larger than what is being viewed by
the end user. Your theoretical refresh time of 60ms is less than the
time required to hit page-up/page-down.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Jul 27 2007 - 20:27:24 CDT
