Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alternatives to SQL Server
Message
From
19/12/2002 13:51:53
 
 
To
19/12/2002 12:30:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00734536
Message ID:
00734600
Views:
21
Geoff,

While "blown out somewhat" is certainly possible, equally possible is an ability to optimize the application so that it can continue fully in VFP.

I've seen a (batch) billing job go from 3 days to 12 hours with no significant change to code (certainly no "redesign"). I've seen an app with 250+ users and 30+ gigs of table data (several tables near 2 gig) have sub-second response time.

Chances are it can be improved. But not without some details of the actual application.

good luck


>Hi Mark
>
>The system we developed has blown out somewhat and is now slowing considerably to the point where some sort of remote server is necessary to remove the network traffic.
>
>I am trying to figure out the best way of achieving this and want to consider what alternatives there are in terms of cost and effectiveness.
>
>Regards
>Geoff Scott
>
>>>Hi
>>>
>>>I was wondering what alternatives there are to SQL Server
>>
>>Oracle, DB2, ... Do you have any requirements that you are looking for?
Previous
Reply
Map
View

Click here to load this message in the networking platform