Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Back-ends for batch jobs
Message
From
28/02/2001 05:42:52
 
 
To
26/02/2001 12:28:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00479602
Message ID:
00480450
Views:
16
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform