vtiger

[pnagendra79]

Dear vTiger Team,

We are using vTigerCRM 5.0.2 Version. Since 2 months onwards CRM became very slow. We are not able to find the solution. We are using only 5 modules. Since our server has high configuration we are still facing problem. Please help me on this issue. How to make it faster.

Currently We have Record Statistics as follows:


Leads: 866
Acounts: 20,437
Contacts: 16648
Trouble Tickets: 1,51,227
Potentials: 19,766


My Server Details are as follows:

Generic Details
Canonical Hostname CRMUN
Listening IP XXX.XX.XX.X
Kernel Version 5.2.3790 SP2
OS/ Distribution Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Server uptime 9 hours 55 minutes
Current Users N.A.
Load Averages 2 0 0 0




Server Memory
Type Percent Capacity Free Used Size
Hardware Memory (RAM) 18% 3.29 GB 729.54 MB 4.00 GB
Disk Swap 2% 1.97 GB 25.00 MB 2.00 GB


Server Drives and Volumes
Mount/Drive Type Partition Percent Capacity Free Used Size
A: Removeable Disk (3 1/2 in.) 0% 0.00 KB 0.00 KB 0.00 KB
C: FAT32 Local Disk 44% 11.08 GB 8.45 GB 19.52 GB
D: Compact Disc 0% 0.00 KB 0.00 KB 0.00 KB
E: NTFS Local Disk 1% 126.26 GB 69.40 MB 126.33 GB
F: NTFS Local Disk 25% 147.29 GB 48.03 GB 195.32 GB
Totals : 17% 284.63 GB 56.54 GB 341.17 GB




Hardware Information
Processors 4
Model Intel(R) Xeon(TM) CPU 3.20GHz
CPU Speed 3.19 GHz
BUS Speed 800 MHz
Cache Size 1024
PCI Devices - Intel(R) E7520 Memory Controller Hub - 3590
- Intel(R) E7525/E7520/E7320 PCI Express Root Port A0 - 3595
- Intel(R) 80332 PCI Express-to-PCI Bridge A - 0330
- DELL PERC 4e/Di RAID Controller
- Intel(R) 80332 PCI Express-to-PCI Bridge B - 0332
- Intel(R) E7525/E7520 PCI Express Root Port B0 - 3597
- Intel(R) E7520 PCI Express Root Port B1 - 3598
- (2x) Intel(R) 6700PXH PCI Express-to-PCI Bridge A - 0329
- Intel(R) PRO/1000 MT Network Connection #2
- (2x) Intel(R) 6700PXH PCI Express-to-PCI Bridge B - 032A
- Intel(R) PRO/1000 MT Network Connection
- Intel(R) E7520 PCI Express Root Port C0 - 3599
- Intel(R) 82801EB USB Universal Host Controller - 24D2
- Intel(R) 82801EB USB Universal Host Controller - 24D4
- Intel(R) 82801EB USB Universal Host Controller - 24D7
- Intel(R) 82801EB USB2 Enhanced Host Controller - 24DD
- Intel(R) 82801 PCI Bridge - 244E
- RADEON 7000 SERIES
- Intel(R) 82801EB LPC Interface Controller - 24D0
- Intel(R) 82801EB Ultra ATA Storage Controllers

IDE Devices - 0: HL-DT-ST DVD-ROM GDR8082N

SCSI Devices - P (Capacity: 0.00 KB)
- D (Capacity: 0.00 KB)
- P (Capacity: 0.00 KB)

USB Devices - (4x) USB Root Hub
- Generic USB Hub


Thanks & Regards,
P.Nagendra.

[mcloide]

It's really hard to say anything that actually will help with your problem, since you haven't given any specific detail of how that is really happening, but try at first to create indexes on MySQL database on the main tables to improve queries speed.
- vtiger_crmentity
- vtiger_account
There are some more that I don't remember by memory, but our system has about 70000 accounts and it's running fine so far in a box that's not a 1/4 of yours.