Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Any ideas to index/speed this up?
Message
De
17/07/2003 03:17:49
 
 
À
17/07/2003 01:53:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00810823
Message ID:
00810974
Vues:
10
Not sure why it wouldn't let me send this earlier, not throwing an error now
SET EXACT off

?"Rating file"
SELECT cdr && cdr is call records in previous
INDEX ON dnis TAG dnis &&DNIS is dialedNo

SELECT rate
index on code tag code desc &&code is dialCode

SET RELATION TO ALLTRIM(code) INTO cdr
SET SKIP TO cdr
replace cdr.rate with rate;
, cdr.dest WITH dest;
, cdr.code WITH code;
, cdr.billdur WITH IIF(cdr.duration >0,IIF(cdr.duration < rate.minimumsec,(rate.minimumsec/60),(CEiLING(cdr.duration/rate.increment)
/60*rate.increment)),0);
, cdr.charge with IIF(cdr.duration > 0,rate*cdr.billdur,0)
FOR empty(cdr.dest)

disregard the improper line changes within the code, it's just wrapping around
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform