Hi Jeremy, Is this JDO/Datanucleus' column validation we are talking about here, where it is verifying its in-memory metamodel of the persistent entities against the RDBMS? Or is it some other sort of query occuring in your code?
I'm guessing the former. Just to narrow this down, if you disable column validation in the persistor_datanucleus.properties file, then does the delay disappear? ~~~ Speculating, I wonder if your app is being bootstrapped without JDO knowing about all the persistent entities, and then only later when you hit this second entity does a whole bunch more of the metamodel become "apparent" to JDO, hence a pause. In earlier versions of Isis we didn't necessarily do a good job of telling JDO/DN about all the entities, though the AppSpec stuff has, I think, sorted out that issue because we now do a classpath scan for all @PersistenceCapables. Are you using an AppSpec, or still relying on isis.properties? Whatever your answers to the above, 9 minutes does sound like a ridiculously long amount of time, so we've obviously got to try to figure this one out for you. Thx Dan On 12 January 2016 at 23:39, Branham, Jeremy [HR] < jeremy.d.bran...@sprint.com> wrote: > I'm experiencing some latency, which I think is occurring due to a large > number of tables in my DB. > The first domain object that is loaded on the home page loads very quick. > But the second loads very slow. > > I notice there is a difference in the column validation query - > The first query has a table name in the 'where' clause. > The second query contains 2 objects/tables in the debugging statement, and > there is no 'where' clause in the SQL. > > Hangs at this line while debugging - > Loading column info for table(s) "OBJECT_A, OBJECT_B" in Catalog "", > Schema "" > > It will eventually return, but it takes about 9 minutes. > I'd like to speed this up, maybe by forcing the column validation to use > the table name every time, or some other way. > > Any thoughts? > > > > Jeremy D. Branham > Technology Architect - Sprint > > > ________________________________ > Learn more on how to switch to Sprint and save 50% on most Verizon, AT&T > or T-Mobile rates. See sprint.com/50off<http://sprint.com/50off> for > details. > > ________________________________ > > This e-mail may contain Sprint proprietary information intended for the > sole use of the recipient(s). Any use by others is prohibited. If you are > not the intended recipient, please contact the sender and delete all copies > of the message. >
