Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Hi Bob,
>
>>Is there anyting that can be done to have the server only deliver the resultant?
>
>Can you show us the SELECT statement and list all the indexes you have created on the tables involved?
>
>Christof
Thanks Cristof..
I did send the info on the SQL's and Tags as a reply on my original thread. I also tried splitting the SQL into 3-statements along with adding a new tag ALLT(site)+ALLT(remoteunit)+ALLT(wh_stat).. I am now down to 1.3 megs from a revised 1.8 megs. give or take some k's. I am NOT yet convinced that using 3-sqls is the answer as my test network has a lot of bandwidth and no traffic today. It also appears that the execution of the browse is a little slower using this approach and my fears are that eventhough the net traffic is less, I am only going out once and not 3 times which may not be better on a busy network. I am still searching for the answer as to WHY and WHAT is being sent to the client amounting to this excess net traffic. Anyway here are the SQL's which will only work in 7.0..
By the way I recently came accross the _Tally failing to update when a record set is 0... It retained a value from a prior SQL... Any thoughts..
ndispvalu='TOP 50 '
cccsite='6'
selethis=[SELE site,instdate,idlc,len,rcntelno,wh_user,wh_stat,wh_comp,action,RECN() AS recn,rsu_no,lastassgn ]+;
[FROM FORCE work_que WHERE ALLTRIM(site)+ALLT(remoteunit)+ALLTRIM(wh_stat)=cccsite+"MIP " INTO CURS sw_curs1 ORDE BY 2 READWRITE]
&selethis
selethis=[SELE site,instdate,idlc,len,rcntelno,wh_user,wh_stat,wh_comp,action,RECN() AS recn,rsu_no,lastassgn ]+;
[FROM FORCE work_que WHERE ALLTRIM(site)+ALLT(remoteunit)+ALLTRIM(wh_stat)=cccsite+"MIP TC" INTO CURS sw_curs2 ORDE BY 2]
&selethis
IF _TALLY>0
* IF RECCOUNT('sw_curs2')>0
SELECT sw_curs1
APPEND FROM sw_curs2
ENDI
selethis=[SELE site,instdate,idlc,len,rcntelno,wh_user,wh_stat,wh_comp,action,RECN() AS recn,rsu_no,lastassgn ]+;
[FROM FORCE work_que WHERE ALLTRIM(site)+ALLT(remoteunit)+ALLTRIM(wh_stat)=cccsite+"MIP R" INTO CURS sw_curs3 ORDE BY 2]
&selethis
* IF RECCOUNT('sw_curs3')>0
IF _TALLY>0
SELECT sw_curs1
APPEND FROM sw_curs3
ENDI
selefrom=[SELECT ]+ndispvalu+[ * FROM sw_curs1 INTO CURS sw_curs ORDE BY 2]
&selefrom
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