|
Problem description: The place I work at runs a program called Retail Pro. Its fairly popular here in Canada and the US. Its an oracle based database but search queries are taking over a minute to come back. So I'd scan a barcode into the computer to see how many are in stock and it could take over 30 seconds for it to retreive the answer. The same slowness is on all of the computers in the company. I was hoping someone here would have had some experience optimizing this software. Attempted fixes: *Ran defrags on the server and used the inbuilt retail pro database optimizer *disabled firewalls (only firewall we have is the one on the router, there isnt a software one) *disabled antivirus *static IPs on all the client comps *went into the ini files of retail pro and increased the availble ram for the program from 4gb to 24gb *added in tonnes of filters like item count must be 1 or higher, must be an active item etc. Operating system: win7 pro I think. System specs: WIn7 pro probably, server is dual octa core, 32gb of RAM, plenty of hdd space in raid 10. I checked today and the server had used 9gb of the 32, and CPU never went above a few percent on one core. There's only one router in the network, the rest are gigabit switches. Even cabled into the same router the server is doesnt help. Location: Canuckland
|
#
¿
Aug 8, 2015 03:49
|
|
|
|
| # ¿ May 9, 2024 23:07 |
|
|
Just on the server. Clients have no anti virus or firewall because they lock the account down and only ever run the POS software anyway, no web browsing allowed. I forget which AV but it was a free one. Maybe nod32. I will check on Monday. The boss swears that he added the Retail Pro folders to the anti viruses ignore list and then even turned it off as a test and no improvement but I guess we could try uninstalling it too. If it was the AV causing problems would the CPU load be a lot higher?
|
|
#
¿
Aug 9, 2015 04:27
|
|
|
Zogo posted:Does this POS software link into the server itself or are they local databases? POS software goes to the server. There's no need for an internet connection from the server or client for any reason. Just FYI, copying from the server to an client PC through windows explorer works as fast as it should, as does the internet. Yeah I'll advise him to uninstall that AV and then reboot everything and try again, he says he tried that before but it was on a previous version and possibly a fair few months ago. I was also thinking maybe add the client IPs to the routers DMZ? Or does that pose a security risk? I don't want to destroy this whole system as he had a cryptlocker a few years ago and doesn't want to go through all that again. Mo, as far as I know its at any time, busy or not. I'm there before the place opens and it might be a bit quicker but not substantially (or it might be the same, i havent timed it exactly). Theres over 900gb free space on the hdd. Typing in the name of the product or uding any other field doesnt yield better results. If this uninstalling AV thing doesnt work, are we getting close to the point where we just shrug and say its the POS software being a jerk? Thankyou both for the help by the way. Zogo I swear you deserve 6 figures for the amount of help you give on these forums. Nierbo fucked around with this message at 02:45 on Aug 10, 2015 |
|
#
¿
Aug 10, 2015 02:42
|
|
|
Yeah server is right on the router. Not sure what the exact OS version is, He;s away for a week so I can't do anything till he's back. I'd say its Win7pro. I will check it for needed updates when I get a chance. Mo, I'm really not sure. Apparently he's had the retail pro guys look at it for hours and hours and weren't able to find a fix. Ugh, wasted probably about 30 minutes today literally standing there and waiting.
|
|
#
¿
Aug 12, 2015 06:46
|
|