Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP and Oracle taking too much bandwith
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00939094
Message ID:
00939218
Vues:
19
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]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform