Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Back-ends for batch jobs
Message
De
28/02/2001 05:42:52
 
 
À
26/02/2001 12:28:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00479602
Message ID:
00480450
Vues:
15
>We have run into the 2 Gig file limit. While there are workarounds possible by splitting files, we are going to take the approach of simply upgrading our backend to a database server.
>
>Our normal back-end is SQl Server (though we use Oracle for a few applications).
>
>We have used VFP as the back end for batch jobs, run against exclusivly opened files. VFP is the fastest thing out there for this kind of thing. (If I'm wrong I would be very interested in hearing what works faster.)
>
>I'm thinking that for this sort of thing SQL Server may not be the best back end. Anyone having any thoughts as to what SQL back end will give us the best performance for huge, string intensive, batch adds and updates where we can get exclusive use of the database, and sometimes even of the server?

Sounds like you´re looking at DB2. I seem to remember that you can turn all sorts of things (like transaction logging) on and off.
That way you should gain a lot of performance.
The pricetag is steep, though!
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform