Wade Maxfield Performance difference between 2 servers, SQLite issue maybe?
Jun 17, 2017; 19:28
Performance difference between 2 servers, SQLite issue maybe?
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?
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: <Lassoemail@example.com> Send administrative queries to <Lassofirstname.lastname@example.org>
Carl Ketterling Re: Performance difference between 2 servers, SQLite issue maybe?
Jun 17, 2017; 09:50
Re: Performance difference between 2 servers, SQLite issue maybe?