R:BASE eXtreme 9.5 (64) Version 9.5.5.20806 Thanks David C. Gideon Controller/Treasurer
Builders Supply, Inc. 8198 E 44th St. Tulsa, OK 74145 PH: 918-628-1211 Fax: 918-627-3710 From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, August 06, 2015 2:34 PM To: David Gideon <[email protected]> Subject: [RBASE-L] - Re: Creating a table using PROJECT COMMAND What version of R:Base? -----Original Message----- From: David Gideon <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Date: Thu, 6 Aug 2015 19:22:46 +0000 Subject: [RBASE-L] - Creating a table using PROJECT COMMAND I am using the following command to create a table named “CUST”. “Project cust from customer_shipments_acctng using *” This command takes from 10 to 12 minutes to complete. The table created contains 9 columns and 40,659 rows. The view takes about 1 second to open. I have also tried “Project temporary cust from customer_shipments_acctng using *” which takes the same amount of time. I have run a command file and also typed it in at the R prompt with the same results. RBASE is on a Windows Server 2008 R2 Standard Processor: Intel® Xeon™ CPU .320 GHz Install memory: 32.0 GB Does anyone know of a faster way to create a table from a view? Any help will be appreciated. Thanks David C. Gideon Controller/Treasurer Builders Supply, Inc. 8198 E 44th St. Tulsa, OK 74145 PH: 918-628-1211 Fax: 918-627-3710
