Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speed issue: VFP app on VM, very large tables
Message
De
04/08/2016 05:30:40
 
 
À
02/08/2016 15:37:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008 R2
Application:
Desktop
Divers
Thread ID:
01639058
Message ID:
01639117
Vues:
89
Which VM provider?

I once tested a Microsoft Azure VM, very powerful as of spec. sheet (Standard A7: E5-2673 v3 8 cores, 56 GB RAM), very slow in practice: 3 times slower than our 4-year old VM (2 Intel(R) Xeon(R) CPU E5-2630 0 @ 2.30GHz, 4 GB RAM) for the same application, same tables

>A client is having speed issues with one instance of their vertical market application. At first, their customer was running it on their own local machine. My client has now moved it to a VM in the cloud. In both of those cases, a particular (very complex) daily process is taking 11-12 hours to run. When my client tested on a local machine at their site with the client's data, it took 3-4 hours.
>
>This customer's data set is quite large, with one table getting close to the 2GB limit but not yet there. The client wants to solve the speed problem first, then split the data. I've suggested doing it the other way, but they're insistent. So first question is whether anyone has any experience with VFP slowing down considerably when processing tables that are close to the 2GB limit. (I've never heard any such thing, but trying to come up with theories.)
>
>The client tells me the same process takes about 2 hours on a similar VM for a customer whose data set is about 75% the size of this customer's. That, combined with the 3x speed-up on a local machine, makes me think this is more a configuration issue than application design.
>
>This is VFP 9 SP2 (don't know about hotfixes).
>VM is Windows Server 2008 R2 Standard x64. It has 100GB hard drive with about 14.5GB free. I believe it's configured with 8GB RAM.
>EXE and data are on the VM; no network involved.
>
>We've looked at the obvious things, like SYS(3050) and where temp files are stored and codepages/collation sequences.
>
>Looking for any suggestions.
>
>Tamar
Thierry Nivelet
FoxinCloud
Give your VFP application a second life, web-based, in YOUR cloud
http://foxincloud.com/
Never explain, never complain (Queen Elizabeth II)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform