Anand,
Since the SQL Anywhere database is usually local to the app, have you
considered your network as the culprit?
Sheldon
> -----Original Message-----
> From: Anand [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, March 08, 2000 2:09 PM
> To: '[EMAIL PROTECTED]'
> Subject: PFCSIG PowerBuilder Oracle performance issues
>
> Hello All,
> I have a general question pertaining to PB - Oracle performance.
> We have a SQL intensive application, which pimarily contains SQL queries,
> and very little graphical interface.
> We have been running in against a Sybase SQL Anywhere database, as well as
> an Oracle database.
> We have discovered that the SQL processing takes considerably longer with
> an
> Oracle database.
> The Oracle database has been tuned by the DBA.
> Does anyone have any suggestions about how the performance against an
> Oracle
> database can be speeded up (Remember the same SQL statement seems to take
> lesser time against SQL Anywhere database).
> Any suggestions welcome.
> Anand
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
