Marc, A view is just a stored SELECT command. Any indexes have to be on the underlying tables.
Bill On Wed, May 6, 2009 at 11:39 AM, MDRD <[email protected]> wrote: > > Is it possible to have Indexes on Views in V8? > > Marc > > > It sounds like you should do the PROJECT TEMP ... command from your view > (include the WHERE clause in your PROJECT), base the report on the temp > table instead of the view. > > Bill > > On Tue, May 5, 2009 at 12:47 PM, A. Razzak Memon <[email protected]> wrote: > >> At 10:25 AM 5/5/2009, Marc Schluter wrote: >> >> The command below takes 2 times longer in V8 compared to the same >>> code in 7.5. >>> PRINT NewForm76D WHERE tr_date BETWEEN 1/1/09 AND .#date AND >>> insco1 = 7 AND compnum = insco1 ORDER BY insco1, custnum, tr_date >>> >>> The report is based on a 6 tab view, Browse all from View using >>> the same where clause only takes 1/4 the time compared to the Print >>> statement. Leaving off the Order by does not make any difference. >>> >>> I am using a copy of the same DB converted to V8, so all data, >>> reports and indexes are the same. >>> >>> I did notice that the #1 file was 46 k now it is 191 k and the # 3 >>> file is almost double the size in V8. Is that normal? >>> >>> I am not sure what to look for next? >>> >> >> Marc, >> >> In addition to all the good suggestions you have already received, >> take a look at your report for "Pass Settings". If you are not >> using the System Variables "Page Set with Description" option, >> such as [Page nn of nn], or DBCalcs with "Look Ahead" option, >> change the Report "Pass Setting" from "Two Pass" to "One Pass". >> >> Here's how: >> >> Report Designer | Main Menu | Report | Pass Settings >> >> This will definitely speed up the PRINT engine. >> >> Once you have made the suggested change, try the following >> command to PRINT the report: >> >> -- Example >> >> -- Start here >> PRINT NewForm76D WHERE Tr_Date BETWEEN 1/1/2009 AND .#DATE + >> AND InsCo1 = 7 AND CompNum = Insco1 + >> ORDER BY InsCo1, CustNum, Tr_Date + >> OPTION SCREEN|WINDOW_STATE MAXIMIZED + >> |ZOOM_TYPE PERCENTAGE + >> |ZOOMPERCENT 98 + >> |PREVIEW_CAPTION New Form 76D >> RETURN >> -- End here >> >> Hope that helps! >> >> Very Best R:egards, >> >> Razzak. >> >> --- 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. >> ================================================ >> >> >> >
