Information générale
Titre:
Remote views (ORACLE ) too slow...
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
Suivant
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