The Spotlight
The Official Blog of The Patron Edge

Giving PEO a 30% speed boost

This tip isn’t for everyone, but for those of you who have an environment where your web server can talk directly to your PE database server, we can eliminate two applications called Queues and Listener and really speed up load times on your PEO site.

To do this requires PEO 3.2.5 or higher and some specific environments. If you have the web site on one box and your PEO/PE databases on a second one and they can communicate directly (using a technology called DCOM), you’re in business. Sorry, hosted PEO folks! Here are the steps to set it up

  1. Stop the PEO Manager Service
  2. Open your ToptixEsro2.ini file and remove Queues and Listener. Be sure to re-number the other applications because PEO Manager service needs them to be in order starting at 0
  3. Edit the Sites table in your PEO database, giving it the following settings
    • stSroIP - machine name of the PE server, or leave it blank if both databases are on one box
    • stSroPort - 999
    • stSyncIP - blank
    • stSyncPort - 0
    • st_eSRO_IP - blank
    • st_eSRO_Port - 0

Now restart the PEO Manager Service and enjoy your new performance gain! Internal testing has shown improvements of up to 30% in performance on database requests, depending on the kind of request being made. You’ll notice that the seat map is particularly zippy. Say goodbye to L300 errors forever!

Posted: Mar 06 2008, 03:12 PM by Nicholai Burton | with 1 comment(s) |
Filed under: , ,

Comments

John Holm said:

Hi Nicholai,

I would love to take advantage of this!

I tried this, and came up with no connection. (on our test server)

I have 2 environments to ask you about:

a: pe,peo, and sql db's on the same box (test server)

b: peo and peo-db on one box, pe and pe db on another (live).

will this work for a and b?

also,

Is there a way to test to make sure the dcom connection works and authenticates?  Are there any components that I might be missing?  Any IIS settings that need to be set?

Your blog is much appreciated!

Thanks,

-John

# August 12, 2008 2:09 PM