Large Active Objects tables?

MattS

Does anyone have experience of how JIRA performs for reading Active Object tables that have just a few columns? Say 500,000 rows and 6 columns, no foreign keys

I want to be able to query for all the rows that match on one field, returning probably less than 1000 matching rows

 

Tibor Hegyi [META-INF]

Hi Matt,

we have Email This Issue customers with having 600K-1M records in a table used to store email logs. The table has many columns as well.

Querying the table with ActiveObjects was never a problem, at least we never received a complaint about query performance and the data set I personally tried on PostgreSQL had approximately 650K records in this table and it was running fine on my laptop.

However, sometimes ActiveObjects execute ALTER TABLE statements. Two of our customers reported performance issues concerning ALTER table statements executed by ActiveObjects on this very huge table. Both of them used mySQL 5.1, so it looked to me that it was mySQL that could not complete the statements.

Again, this is ALTER TABEL not a SELECT. SELECT was always acceptable.

We had an Atlassian event (like an AUG) yesterday and there was a presentation about using Querydsl to query huge plugin tables with extremely good performance. So there is an easy and promising alternative to ActiveObjects when it comes to querying AO tables within an addon.

Tibor