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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement