Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
JVP, flexibility of databases
Message
De
20/11/2003 02:17:18
Dorin Vasilescu
ALL Trans Romania
Arad, Roumanie
 
 
À
19/11/2003 12:33:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00851534
Message ID:
00851734
Vues:
25
Hi Mike,
"Just as fast"?
I think that you can much faster, and not only Fox + native DBF's, but even Fox + SQL Server.

Suggestion:
Posting samples, or even lines of code, with how things can be done in Foxpro+DBF or Foxpro+SQL Server and what is needed for the same thing to be achieved using ADO.NET + SQL Server

Example (client-server):
SQLPREPARE(nHandle, ;
[INSERT INTO some_table (col1, col2, col3, col4) values (?m.col1 , ?m.col2, ?m.col3, ?m.col4)])
SQLEXEC(nHandle)
Or, how to do lookup in a 3000 customers table ?
With Foxpro, easy, SET KEY or SEEK, instantly, without the need that entire table to be loaded in memory.

Or, how to work OFFLINE, again, for client-server?
With Foxpro, easy, offline views or local tables.

I think this thread will be interesting.


>Hi John,
>
>You said:
>
>>The fact is - it cannot be demonstrated that the combination of ADO .NET + SQL Server cannot be more flexible and faster than Fox + native DBF's.
>
>Removing the double negative, just for clarity sake:
>
>It can be demonstrated that the combination of ADO .NET + SQL Server can be as flexible and as fast as Fox + native DBF's.
>
>I think that I can demonstrate that Fox programs accessing Fox data can be more flexible and just as fast.
>
>I bet I can demonstrate this.
>
>How do we proceed? Using the UT Member's critieria as a suggested guidelines for flexibility is obviouslly going to be biased. Do you have suggestions that can even out this bias?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform