Are you sharing the connection of the views? If you are going to create a new connection every time, then yes, that overhead will be there.
I also assume you will be putting WHERE clauses on these views with some parameters.
BOb
>Hi All,
>
>I 've done first draft of my app and installed to test how my forms behave when accessing ORACLE over the network.
>It tooks for the table with only 7 fields about 4-5 sec to open and with 20 fields around 15 sec.
>
>I have set up in every form in BeforeOpen method SET TALK OFF and SET DELETED ON
>and i set NODATA on load to .T. for every cursor in my dataEnvironment.
>
>..now i tried something differently
>
>Installed EXE and remote database on the server itself ( ORACLE database ) and my forms opens instantaneously.
>
>Went back to my PC and just test the remote views like this:
>I have table Phone_book with only 7 fields and no parameters passed so my SELECT is
>
>SELECT Phone_book.PHONEID, Phone_book.NAME, Phone_book.GSM_NO,;
> Phone_book.WATER, Phone_book.SEWER, Phone_book.MECHELEC;
> FROM GCC.PHONE_BOOK Phone_book
>
>or
>
>SELECT *;
> FROM GCC.PHONE_BOOK Phone_book
>
>create a program...
>
>
>* of course open database GCC_REMOTE
>clea
>wait window 'Start...' + time() nowait
>?'Start...' + time()
>*use servicerequest_all && my remote view
>use phone_book_all && my remote view
>wait window 'End...' + time() nowait
>?'End...' + time()
>
>...and it tooks 4-5 sec to open ( source table has only 2-3 records )
>
>
>my other view has 236 fields ( remote view servicerequest_all)
>
>SELECT *;
> FROM GCC.SERVICEREQUEST Servicerequest
>
>
>..also take 5 sec to open ( has only 2 records ).
>
>My form SERVICE REQUEST in the application contains only 20 fields. It takes about 14 sec to open up and form PHONEBOOK ( with 7 fields ) takes
>4 sec to open. It's like minimum connection time plus time for loading the forms controls.
>
>It seems to me it is issue with connection to the ORACLE over the network ( TCP/IP ).
>
>Can anybody give me some ideas what should i do to make things happen faster.
>
>Maybe it is ORACLE Listener i need to configure correctly.
>At the moment it is setup as :
>
>Protocol TCP/IP
>Host NTCAB1
>Port 1521
>
>
>Thanks for response.
>
>Regards
>
>Dejan
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement