02 Sep 2010 
Icewarp Support Center » Knowledgebase » Technical Help » Version 9 Webmail » Setting Up P.D.O. In Webmail PRO For Faster Performance
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
 Setting Up P.D.O. In Webmail PRO For Faster Performance
Solution

In version 9.1.0, and any after, will take advantage of the new PHP DATA OBJECTS (P.D.O) in the new webmail PRO. This allows for faster caching of the headers and retrieval of messages in the users mail box. The way this works is when logging into webmail once the P.D.O. is setup it will at that point cache all the current message headers in the database you setup. The first initial login will take a little longer depending on the amount of messages but after the existing message headers are cached you will see faster load times from that point out. This is extremely useful for customers with heavier webmail usage.


To set this up you first need to have the database installed. In this example we will be using MySQL. Once the MySQL server is installed and setup you would create a database for the P.D.O. and name it accordingly.



You will now have to take the libmysql.dll from your MySQL's /bin directory and place it in the /Icewarp/php folder. You also have to uncomment the driver in the PHP.INI file in the /merak/php folder. Open the PHP.INI file and uncomment the extension=php_pdo_mysql.dll there. ** For MSSQL you would need to uncomment the extension=php_pdo_odbc.dll line.



After creating the database and performing the other steps needed you would then create a system ODBC to connect to the new P.D.O. database.



Once the database and ODBC is setup you would go into the Icewarp consoles [Webmail] tab and setup the connection there. You will see the preset MySQL string and others already configured in the PDO drop down. You would need to swtich the dbhost= to where ever the server is located, if installed locally then localhost would remain. You would then specify the dbname= to the name of the PDO database you just created. lastly, you would provide the username and password to connect to the database.



Now restart the services and once they start all users who login will have all existing messages cached into the newly defined P.D.O. database.


Article Details
Article ID: 93
Created On: 24 Oct 2007 05:21 PM

 This answer was helpful  This answer was not helpful

 Back
Home | Register | Submit a Ticket | Knowledgebase | Troubleshooter | News | Downloads
Language: