http://forums.vtiger.com/viewtopic.php?t=17856&highlight=load+slow
Turning Mysql
[mysqld]
basedir=C:\programy\VertrigoServ\Mysql\
datadir=C:\programy\VertrigoServ\Mysql\data\
port = 3306
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 2M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 512K
character-set-server=utf8
collation-server=utf8_polish_ci
default-character-set=utf8
init-connect=SET NAMES utf8
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server=C:\programy\VertrigoServ\Mysql\bin\mysqld.exe
Turning PHP
max_execution_time = 30
; Maximum execution time of each script, in seconds
max_input_time = 120
; Maximum amount of time each script may spend parsing request data
memory_limit = 32M
; Maximum amount of memory a script may consume (8MB)
