Hi,
We have finally made the conversion to Turbo 8, and am having
troubles with my month end financial processes. I assumed it was
index problems and made sure there are indexes.
Update ardetail set invcur = 0, paycur = 0
used to take seconds in 7.5 26 hours and counting in turbo
in 7.5 neither invcur nor paycur had indexes.
I added them now, and still no increase in speed. So then I
thought, ok with the new indexes, lets key just off those..
Update ardetail set invcur = 0 where invcur <> 0 (excluding 95000
rows) only 1300 should now be looked at, and this still takes forever.
Where should I look next?
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
