>I don't know why your view definitions should take long to run. Your only creating the definition of the view, not running the query for the view itself...or are you running the query?
>
I was pretty much surprised myself. The following code takes about .40 sec to run:
CREATE SQL VIEW VChildren AS ;
SELECT "..." AS ChOrder, ;
CH.ChKey, ;
CH.ChIbKey, ;
CH.ChFirstNam, ;
CH.ChLastName, ;
CH.ChBirthDat, ;
CH.ChKindeduc, ;
CH.ChOwnIncom, ;
CH.ChDeductio, ;
CH.ChRemarks ;
FROM Child Ch ;
WHERE CH.ChIbKey = lcParentKey ;
ORDER BY CH.ChKey
The reason is the "..." AS CHOrder statement. I need this additional field in the view. Without this, the code takes 0.07 sec.
Christian Isberner
Software Consultant