Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADVICE: DATABASE BACKEND & SERVER
Message
 
À
17/03/1997 23:23:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00024561
Message ID:
00024730
Vues:
31
>>I don't want to start a "My database is better then your database" war ... but I need advice.
>>
>>We are have two servers connected by a hub:
>>#1 10BaseT\Ethernet - Novell 4.1
>>#2 Coax - Novell 3.1
>>
>>We will need to connect the new network to existing networks.
>>The current 4.1 network is max'ed out.
>>
>>Currently, we use Foxpro\Visual Foxpro\Visual Basic for our database needs. We need to start working with some gig sized databases (number crunching\accounting stuff). Assuming we use Visual Foxpro\Visual Basic, there are two questions.
>>
>>What operating system do we go with (NT Server or Netware).
>>What SQL backend should we use (MS SQL Server/Oracle/Sybase/etc)?
>>
>>We are mostly accountants here that also do programming but know very little about networking & client-server. We do not have a systems administrator (I hate installing software that says "Ask your network administrator".) Obviously we are going to have to take classes in whatever platforms we choose.
>>
>>But which platforms?
>>
>>Thanks,
>>Gene Berger
>>Nationwide Warehouse & Storage
>>Columbus, OH
>
>
>My recommendation is NT with Microsoft SQL Server. Oracle will require Unix and that means more headaches for you and you'll most likely need a fulltime DBA. Also...NT with MS SQL Server will probably be less expensive than other options.
>
>Craig

I agree with Craig, and from my experience (as CNA) with Novell 4.1, I would say that NT would be easier to maintain. Also, from my client-server experiense (VFP 3.0b/Sybase so far), carefully plan your approach to transactions processing from the beginning, because often requeries/updates of the back end can significantly increase processing time with hudge databases, and sometimes make it unacceptable.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform