Jun 17
Wade Maxfield Performance difference between 2 servers, SQLite issue maybe?
Jun 17, 2017; 19:28
Wade Maxfield
Performance difference between 2 servers, SQLite issue maybe?
Hey List,
I’m after a little bit of help to diagnose a very particular performance issue with Lasso 8.5.6.
I have 2 servers, and the difference in performance between them for some actions has me stumped.
Server 1 (Dev) is a Mac Mini 2.6GHz Quad Core i7, OS X 10.10, Lasso 8.5.6.
Server 2 (Live) is Xserve 2.26GHz 2x Quad Core, OS X 10.10, Lasso 8.5.6.
Machines perform similarly with most Lasso pages (straight forward code, grabbing data from MySQL, etc).
But, server 2 is particularly slow when accessing some pages in ServerAdmin.lassoapp and SiteAdmin.lassoapp, for instance editing the path permissions in Setup > Security > Files > Path Permissions. It can take 3-4s to load the page when you click on the path to edit, 4-6s when you hit assign to submit the form. The same action on server 1 takes 200-400ms to load, 500-650ms to assign.
The bigger issue is with Email_Send. Both servers are set up the same in Utility > Email > Setup, with Ignore -Host Param set to yes, Send Directly to SMTP Servers set to no. I’ve wrapped the Email_Send with a quick timer using _date_msec. Queuing the email with Email_Send on server 2 takes 1500-1900ms, exact same code/email on server 1 takes 90-110ms. More than a factor of 10 difference.
Starting Lasso from terminal via startLassoService.command is also noticeably slower on server 2.
All signs seem to be pointing to slow performance with the SQLite tables that Lasso uses for settings and email. I thought there might be some sort of SQLite corruption so I’ve clean installed Lasso from scratch on server 2 and manually entered all the settings again, and it’s still just as slow.
CPU usage via top for any Lasso process on the machine doesn’t go above 5%, but something is causing the delays.
What else can I try or where else can I look to sort this out?
- Wade
#############################################################
This message is sent to you because you are subscribed to
the mailing list Lasso Lasso@lists.lassosoft.com
Official list archives available at http://www.lassotalk.com
To unsubscribe, E-mail to: <Lasso-unsubscribe@lists.lassosoft.com>
Send administrative queries to <Lasso-request@lists.lassosoft.com>
Jun 17
Carl Ketterling Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 17, 2017; 09:50
Carl Ketterling
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18
Wade Maxfield Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18, 2017; 10:05
Wade Maxfield
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18
Carl Ketterling Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18, 2017; 13:35
Carl Ketterling
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18
Marc Pinnell Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 18, 2017; 13:31
Marc Pinnell
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 19
Wade Maxfield Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 19, 2017; 08:56
Wade Maxfield
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 19
Wade Maxfield Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 19, 2017; 09:02
Wade Maxfield
Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 26
Wade Maxfield Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 26, 2017; 13:24
Wade Maxfield
Re: Performance difference between 2 servers, SQLite issue maybe?