Karen
Since the temp table is dropped as soon as you disconnect from the database I prefer dropping it at the end of my application. I would also make sure to drop them before a reload or pack. Buddy From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: Tuesday, January 08, 2013 11:18 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Thoughts about temp tables? Since the list has been slow, let me throw a question out there. When you write a program that uses temp tables, do you leave the temp tables out there? Or do you delete them? I always leave them, simply because I sometimes want to get to the r> prompt and look at the temp table. I'm not sure whether there's any space/memory/performance issues with having them there. The reason it comes to mind is that last week I had a program fail, and it turns out that another programmer on this client (we work as a team) and I happened to pick the same name for a column to use in a temp table, and of course we used a different data type! If I work alone I have a pretty good memory of what I might have used for temp table column names (although not 100%). And I try to use existing column names whenever possible. What do you do? Karen
