Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odometer on SQL table load
Message
From
11/05/2000 15:04:43
 
 
To
11/05/2000 14:57:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00368368
Message ID:
00368729
Views:
16
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).
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform