I am having a yii application wich also have several restfull functions, right now i am having about 50 users heavily making queries or bulk insertions, i am experiencing a total hold on the web to return model queries whenever bulk inserts so the web wont respond if a user is using the restfull with inserts or updates
the bd is in oracle 10g , the app is in yii 1.1.13
is concurrency on table querying an issue in yii-oracle or there is certain configuration to be accomplished to get it working fine with no locking or holds with concurrent queries?
the JDBC connection (squirrel or sql client) works just fine while app is held by restfull querying so i guess it could be configuration with oci8