Re: Performance

In article <3kt1jh$hui@dodge.eng.sc.rolm.com>, Peter Levine <peterl@minerva.robadome.com> wrote: >Thanks Helen and Jack for the quick response. > >I restructured the query and have considerably >improved its performance. Query time has gone from over 8 minutes to less >than 8 seconds. > ... > >To improve performance I broke the original query into 4 separate >queries using the technique of substituting sorting in temporary tables >to avoid nonsequential disk access. This technique is described in >Chapter 4 of the INFORMIX "Guide to SQL Tutorial" - Using a Temporary >Table to Speed Queries. (Lots of other good stuff in this chapter too.) > This is good. I've read about creating temporary tables and use them for faster queries. But what about if two or more persons are using the same data-entry screen? Will making a 'fixed' temporary table name let one user succeed and the other one fail with a 'table already exists' error? -- - J -