Help tuning a login script
I have the attached login script that is running a bit slow (15 seconds) so I'm hoping someone has some suggestions for making it faster?
The basic logic is to get the account name, compare it to a table of usernames to find the VetID (aka company ID, then set the VetID into a global variable (gVetID) that is used to limit the records in the layouts (along with user security). For internal users there is no VetID so gVetID is null. If there is a VetID >0 then I send the user to one layout, if not they are an internal user so I check the devise type and then direct them to the applicable layout.