Too slow login.

[avinazz]

Hi all..

i am using sugarcrm and i need to speed up authentication process........

i guess there is something abnormal that it takes about 1.5 minutes to login....

plz help me to sort out this problem....

thanks.

[stevec]

A few questions...

Once you have logged in, is fast - or do most of the other clicks cause long waits?

Are you using LDAP authentication?

Is the database on the same machine as the web server?

Thanks

[avinazz]

Thanks for reply....
My answers:
1)Everything else works fine.
2)No.
3)Yes.

i also have VMWare running on same system...

[stevec]

OK - I wouldn't have thought it an issue if the database is on the same machine but try this.

Edit the mysql config file and under [mysqld] add the line:

skip-name-resolve

and then restart mysql

Thanks

[avinazz]

Thanks a lot Stevec

It worked like a charm.........login time is now 7 secs. approx.

hope everything goes smooth here on...

thanks again....

[stevec]

Cool - but 7 secs still sounds long . Check out the old threads and wiki entries on increasing performance of the web server (compression, caching and accelerating).

Steve