topic Re: Startup speed and number of sql queries in Alfresco Archive

Startup speed and number of sql queries

krm1312 — Fri, 26 Sep 2008 02:19:18 GMT

I am experimenting with Alfresco and DoCASU. I am a bit disappointed in the startup speed and did a little digging (hoping there was a magic "go-faster" flag). When on a local network with the database (MySql 5), startup speed is on the order of a minute. On a non-local network (vpn) with a round

Re: Startup speed and number of sql queries

krm1312 — Fri, 26 Sep 2008 02:39:39 GMT

Just as a comparison, I exported the database (all 384k uncompressed mysqldump) and locally the same aflresco instance starts up in 19s on the same machine. So it's clearly just latency due to the number of queries and the round trip time.

–Kevin

Re: Startup speed and number of sql queries

pmonks — Fri, 26 Sep 2008 03:57:57 GMT

Currently Alfresco is quite "chatty" with respect to the database, so ensuring the connection between Alfresco and the database is high bandwidth / low latency and has minimal contention is very important from a performance perspective.

Cheers,
Peter

Re: Startup speed and number of sql queries

fschnell — Fri, 26 Sep 2008 19:15:52 GMT

Hi

can you tell me how to turn on hibernate's sql logging?

Tx
Frank

Re: Startup speed and number of sql queries

pmonks — Fri, 26 Sep 2008 19:34:21 GMT

Hibernate uses a system property called "hibernate.show_sql" that controls whether SQL is logged or not (see http://www.google.com/search?q=hibernate.show_sql for details).

Cheers,
Peter