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
