Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP and Oracle taking too much bandwith
Message
From
03/09/2004 13:15:26
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00939094
Message ID:
00939218
Views:
18
Heya Mario -
is your oracle spt thingie optimized ? check your oracle schema for the db.
1. are you using a primary key for update/fetch ?
2. if you are doing inserts, is there a stored proc / trigger that is firing on the backend?

can you provide an example of one of your spt's ?

Typically - I try to match up what ever is in the where clause
with columns on a back end that are indexed.
If a column is not indexed, then on a fetch - you will kick the db server into table scan mode.

on an update - it will be a bit slower too - but not as slow as a tablescan

on an insert - it won't matter [usually]

mondo regards [Bill]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform