Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odometer on SQL table load
Message
De
11/05/2000 15:49:43
 
 
À
11/05/2000 15:04:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00368368
Message ID:
00368772
Vues:
12
Sat around 4:30. Just enough time to maybe take a little nap. SSS, then go out for the nite.

PF

>When are you getting there? I'm arriving about 8PM tomorrow night.
>
>
>>I'm getting very thirsty for some NO alchohol. Just ordered a DVD of the Denver whopping GB Superbowl. Sorry no Dolphin DVDs available since they haven't won anything in ohhhh about a decade or so.
>>
>>PF
>>
>>>I think Perry raised a valid point: Why create a view in VFP on a million record table. Suboptimal. Create a stored procedure on the server which accepts a parameter and sends back a result set. Less roundtripping and MUCH, MUCH faster.
>>>
>>>>How do you turn off odometer on the load of an SQL table from a view?
>>>>
>>>>I did a Set talk off and then set odometer to 10000, but STILL, when I open an SQL table in Foxpro from a view, it showers a counter by 100s and it is SLOW (on a million record file).

(On an infant's shirt): Already smarter than Bush
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform