That's what I was wondering about. I will probably do something like that if I see any slowdowns at all (that aren't fixed by indexing, normalization, etc.)
Thanks On Thu, Jun 16, 2011 at 8:40 AM, TOM HART <[email protected]> wrote: > I see an increase in speed over a network. I have some popup menus in > multiple form fields(from various tables with the data I want). When the > form starts that data is loaded into temp tables for the popup menus, there > is a noticable difference in speed between popups from the tables vs popups > from the temptables. Since I enter 500-1000 rows of data per day of which > some ends up not needed(ie deleted before final entry) using temp tables and > the insert seems to keep my database from growing so fast due to deletions > from permanent tables. In my opinion temp tables are great. > Tom Hart > > ------------------------------ > *From:* William Stacy <[email protected]> > *To:* RBASE-L Mailing List <[email protected]> > *Sent:* Thu, June 16, 2011 10:18:58 AM > *Subject:* [RBASE-L] - temporary tables > > Is the push for using temp tables based on processing speed, data safety, a > combo, or what else? > > -- > William Stacy, O.D. > > Please visit my website by clicking on : > > http://www.folsomeye.net > > > > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
