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