Oracle Connect via OCI8 Client 12.1 takes so long for first request

[ChrisFeldmeier]

Oracle Connect via OCI8 Client 12.1 takes so long for first request Can something be tuned or why is it soooo slow? Reponse time 6 seconds for a simple table with 5 rows???

php.exe --ri oci8
OCI8 Support => enabled
OCI8 DTrace Support => disabled
OCI8 Version => 2.0.10
Revision => $Id: 8effa3c719ada4f4f79587ac85aca57b3b9f9b38 $
Oracle Run-time Client Library Version => 12.1.0.1.0
Oracle Compile-time Instant Client Version => 12.1

Directive => Local Value => Master Value
oci8.max_persistent => -1 => -1
oci8.persistent_timeout => -1 => -1
oci8.ping_interval => 60 => 60
oci8.privileged_connect => Off => Off
oci8.statement_cache_size => 20 => 20
oci8.default_prefetch => 100 => 100
oci8.old_oci_close_semantics => Off => Off
oci8.connection_class => DREAMFACTORY_STAGE => DREAMFACTORY_STAGE
oci8.events => Off => Off

Statistics => Active Persistent Connections => 0 Active Connections => 0

[drewpearce]

Have you tried in the latest version of DF? There were performance enhancements made in the 2.2 release.

[ghost]

Is this DF caching the schema? The first request can be slow if there are a bunch of tables