Lasso 8 performance issue

classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Lasso 8 performance issue

Alexander Dewilde

We have a production server running Lasso Pro 7.0.6. Runs perfectly!
(OSX Server 10.3.9 - Apache 1.3.29 - MySQL 4.1.11)
 
We also have a development server running Lasso Pro 8.0.5 for implementing new features and testing before turning into production.
(OSX Server 10.3.9 - Apache 2.0.52 - MySQL 4.1.12)

The idea is to turn the dev server into production is all sites are fast and stable.

Performance tests pointed out the production server (single 1GHz processor) was about twice as fast, running the exact same site, while the development server has a dual 2GHz processor...

After spending many hours of tracking down the issue, I found this rather disturbing result:
-reboot both machines (clean buffers etc.)
-performance test on production server (about 10 mysql queries): 0.107 seconds
-same performance test on dev server (about 10 mysql queries): 0.286 seconds

-log in to the siteadmin.lassoapp on dev server + same test: 0.054 seconds .....?!?!?!
(doesn't change when you hit logout on the siteadmin page)
(changes back to slow results when quitting browser and retry without login to siteadmin)
(same results when using Lasso Pro 8.0.3 on dev server)

We use our own session management and the lasso internal session setting is set to memory.
We do not use lasso cacheing.

Any suggestions?


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alan Linnenbank
Are you using the same hardware for databaseserver on dev and live servers? Or are you running MySQL locally on the webserver in bopth cases?

Alan

On donderdag, 9 juni 2005 13:18, Alexander Dewilde <[hidden email]> wrote:

We have a production server running Lasso Pro 7.0.6. Runs perfectly!
(OSX Server 10.3.9 - Apache 1.3.29 - MySQL 4.1.11)
 
We also have a development server running Lasso Pro 8.0.5 for implementing new features and testing before turning into production.
(OSX Server 10.3.9 - Apache 2.0.52 - MySQL 4.1.12)

The idea is to turn the dev server into production is all sites are fast and stable.

Performance tests pointed out the production server (single 1GHz processor) was about twice as fast, running the exact same site, while the development server has a dual 2GHz processor...

After spending many hours of tracking down the issue, I found this rather disturbing result:
-reboot both machines (clean buffers etc.)
-performance test on production server (about 10 mysql queries): 0.107 seconds
-same performance test on dev server (about 10 mysql queries): 0.286 seconds

-log in to the siteadmin.lassoapp on dev server + same test: 0.054 seconds .....?!?!?!
(doesn't change when you hit logout on the siteadmin page)
(changes back to slow results when quitting browser and retry without login to siteadmin)
(same results when using Lasso Pro 8.0.3 on dev server)

We use our own session management and the lasso internal session setting is set to memory.
We do not use lasso cacheing.

Any suggestions?


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alexander Dewilde
In reply to this post by Alexander Dewilde

Alan,

Both servers act as standalone machines (apache,lasso,myql... all on the same host)

Behavior is as expected only when logging in to lassoadmin (and changing nothing!)



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alan Linnenbank
In reply to this post by Alexander Dewilde
Are You using the same harddisk(speed/interface)? same ram(amount and speed)?

Alan


On donderdag, 9 juni 2005 13:33, Alexander Dewilde <[hidden email]> wrote:

Alan,

Both servers act as standalone machines (apache,lasso,myql... all on the same host)

Behavior is as expected only when logging in to lassoadmin (and changing nothing!)



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alexander Dewilde
In reply to this post by Alexander Dewilde

Alan,

It really doesn't matter what disks, memory etc. is used...
The thing is: expected performance is only happening after logging in to the admin setion

(I understand by logging in to the admin section, you create a lasso internal session... but I don't see how this could influence performance?! especially since we don't use lasso built-in sessions and cacheing)



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alan Linnenbank
In reply to this post by Alexander Dewilde
Logging in to the siteadmin also sends username and password to the Lasso Service, maybe because the siteadmin has more priv's (or they are broather defined or something) then the "anyuser" lasso can operate faster?



Alan

On donderdag, 9 juni 2005 13:50, Alexander Dewilde <[hidden email]> wrote:

Alan,

It really doesn't matter what disks, memory etc. is used...
The thing is: expected performance is only happening after logging in to the admin setion

(I understand by logging in to the admin section, you create a lasso internal session... but I don't see how this could influence performance?! especially since we don't use lasso built-in sessions and cacheing)



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Bil Corry
In reply to this post by Alexander Dewilde
> expected performance is only happening after logging in to the admin setion

Perhaps being logged in as the admin means Lasso has less security overhead to
do.  You can test it by adding:

        [auth_admin]

to the top of the first page of your site, logging in with your site admin un/pw
then running through your tests.  Logging into the site admin lassoapp
accomplishes the same thing.

The other thing to consider, although probably not the issue, is if the site
wasn't running for some reason, Lasso retarts it on the first hit to the site.
So hitting the site admin lassoapp would start it up and subsequent hits (i.e.
your tests) would run at full speed.  You can test this by hitting your site
once with your test script.  Wait a minute or so.  Then reload the page and see
if it's now faster.


- Bil

------

Bil Corry
[hidden email]

Enterprise internet application development and security consulting
  http://www.fivegeeks.com/

Tools for Rapid Lasso Development
  http://www.lassoware.com/
 
-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of
Alexander Dewilde
Sent: Thursday, June 09, 2005 4:50 AM
To: [hidden email]
Subject: Re: Lasso 8 performance issue


Alan,

It really doesn't matter what disks, memory etc. is used...
The thing is: expected performance is only happening after logging in to the
admin setion

(I understand by logging in to the admin section, you create a lasso internal
session... but I don't see how this could influence performance?! especially
since we don't use lasso built-in sessions and cacheing)




--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alan Linnenbank
In reply to this post by Alexander Dewilde


>Perhaps being logged in as the admin means Lasso has less security overhead to
>do.  You can test it by adding:



That's what I thought. Maybe my poor english didn't state it clear enough.

Alan Linnenbank



------

Bil Corry
[hidden email]

Enterprise internet application development and security consulting
  http://www.fivegeeks.com/

Tools for Rapid Lasso Development
  http://www.lassoware.com/
 
-----Original Message-----
From: [hidden email] [mailto:[hidden email]] On Behalf Of
Alexander Dewilde
Sent: Thursday, June 09, 2005 4:50 AM
To: [hidden email]
Subject: Re: Lasso 8 performance issue


Alan,

It really doesn't matter what disks, memory etc. is used...
The thing is: expected performance is only happening after logging in to the
admin setion

(I understand by logging in to the admin section, you create a lasso internal
session... but I don't see how this could influence performance?! especially
since we don't use lasso built-in sessions and cacheing)




--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Jim Van Heule
In reply to this post by Alexander Dewilde
My best guess is that you have some process that isn't properly  
authenticated (Lasso privileges) so when you log in as admin, it runs  
at full speed. When not logged in, it hangs for a bit on the process  
it is stuck on before it moves forward.

That has happened to me when I had a page doing something that isn't  
readily apparent on the page being viewed such as a page counter or  
some type of logging routine that wasn't properly coded.

Just a thought.

--
Jim Van Heule
Heunox Corporation
[hidden email]
(616) 844-0066



On Jun 9, 2005, at 7:56 AM, Alan Linnenbank wrote:

> Logging in to the siteadmin also sends username and password to the  
> Lasso Service, maybe because the siteadmin has more priv's (or they  
> are broather defined or something) then the "anyuser" lasso can  
> operate faster?
>
>
>
> Alan
>
> On donderdag, 9 juni 2005 13:50, Alexander Dewilde  
> <[hidden email]> wrote:
>
> Alan,
>
> It really doesn't matter what disks, memory etc. is used...
> The thing is: expected performance is only happening after logging  
> in to the admin setion
>
> (I understand by logging in to the admin section, you create a  
> lasso internal session... but I don't see how this could influence  
> performance?! especially since we don't use lasso built-in sessions  
> and cacheing)
>
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>
>
>
> --
> ------------------------------
> Lasso Support: http://support.omnipilot.com/
> Search the list archives: http://www.listsearch.com/lassotalk.lasso
> Manage your list subscription:
> http://www.listsearch.com/lassotalk.lasso?manage
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alexander Dewilde
In reply to this post by Alexander Dewilde

Just reinstalled everything... same results

Tried this simple page: test.lasso

[loop:1000]
[inline:-database=$mydatabase,-sql='select * from '+$mydatabase+'.testtable where condition="parameter"'][/inline]
[/loop]

[auth_admin]
[loop:1000]
[inline:-database=$mydatabase,-sql='select * from '+$mydatabase+'.testtable where condition="parameter"'][/inline]
[/loop]

What do you know: first loop part of the code: slow.
After authentication: waaaaay much faster (200% - 400%)

Once authenticated: keeps on running in high speed!

I'm in the dark here!

--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: Lasso 8 performance issue

Alan Linnenbank
In reply to this post by Alexander Dewilde
Could it be because youre not specifiyng a -table? I suspect that once authenticated as admin lasso doesn't have to check permissions for that anymore.

Alan



On vrijdag, 10 juni 2005 11:54, Alexander Dewilde <[hidden email]> wrote:

Just reinstalled everything... same results

Tried this simple page: test.lasso

[loop:1000]
[inline:-database=$mydatabase,-sql='select * from '+$mydatabase+'.testtable where condition="parameter"'][/inline]
[/loop]

[auth_admin]
[loop:1000]
[inline:-database=$mydatabase,-sql='select * from '+$mydatabase+'.testtable where condition="parameter"'][/inline]
[/loop]

What do you know: first loop part of the code: slow.
After authentication: waaaaay much faster (200% - 400%)

Once authenticated: keeps on running in high speed!

I'm in the dark here!

--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage



--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage