I agree. Properly design indexes will make a huge difference. Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 From: [email protected] [mailto:[email protected]] On Behalf Of Gary Wendike Sent: Thursday, August 06, 2015 8:39 PM To: [email protected] Subject: [RBASE-L] - Re: Creating a table using PROJECT COMMAND David, the result of 10-12 minutes on 40,569 rows indicates something is wrong in the way data is being gathered. I generate multiple tables bigger from views than what you are working with and they do not take anywhere close to the time you are indicating. I would say it could relate more to view command than the project command. Gary From: [email protected] [mailto:[email protected]] On Behalf Of David Gideon Sent: Thursday, August 06, 2015 2:41 PM To: [email protected] Subject: [RBASE-L] - Re: Creating a table using PROJECT COMMAND 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]> To: [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 _____
No virus found in this message. Checked by AVG - www.avg.com Version: 2015.0.6125 / Virus Database: 4401/10387 - Release Date: 08/06/15
