db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <kristwaa.apa...@gmail.com>
Subject Re: Performance issue with same index name in multiple schemas
Date Fri, 05 Feb 2016 15:02:35 GMT
Den 05.02.2016 13.22, skrev kosurusekhar:
> Hi All,
> 
> We are having three schemas with almost same table structure, indexes,
> queries, stored procedures in one database. But in one schema we are facing
> some performance issue. We are having same index names and table names in
> all schemas. In another schemas it is running without any problem. In one
> schema with basic load only application is becoming slow. 

Hi Sekhar,

Are the schemas approximately the same size in terms of data inserted
into the database?
Also, are the access patterns / loads roughtly the same?

Otherwise I'd follow some of Brett's pieces of advice. If you can
identiy the slow query (and the tables / indexes involved), you can
compare the plans for the performant schema and the slow schema.


Regards,
-- 
Kristian

> 
> Is there any relationship with table names and index names with multiple
> schemas? What ever we have queries/stored procedure's with performance
> issues, these queries/stored procedure's running with out any issue in
> another schema's. I am not understanding what is going wrong.
> 
> I could see some times single transaction is locking couple of tables more
> than once and not releasing. At this point of time we are feeling the
> slowness. 
> 
> Please help me with some points to sort out this situation.
> 
> Thanks in advance.
> 
> Regards
> Sekhar.
> 
> 
> 
> --
> View this message in context: http://apache-database.10148.n7.nabble.com/Performance-issue-with-same-index-name-in-multiple-schemas-tp145507.html
> Sent from the Apache Derby Users mailing list archive at Nabble.com.
> 


Mime
View raw message