Thanks to all of you. It looks like I need to work on streamlining the views. There are four views used to produce the customer_shipments_acctng view. These views extract data from five difference SQL tables.
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 Ken Shapiro Sent: Thursday, August 06, 2015 7:21 PM To: David Gideon <[email protected]> Subject: [RBASE-L] - Re: Creating a table using PROJECT COMMAND Hi David, As Razzak suggested in his previous email, check how the tables are linked in the view and what the indices are. You can post back here for the very best of assistance money can’t buy. ☺ I read your post and became interested in timing how long it takes to project a table with 31 columns and 7.7 million rows. I have a run of the mill older i7 desktop with not the very fastest in hard drives..not even SSDs. Time to completion was 25 seconds meaning RBASE went at a speed of 310,400 rows/second. That is FAAAAST. A little database tuning can go a long way to resolve some performance issues. Regards, Ken From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of David Gideon Sent: Thursday, August 06, 2015 3:41 PM To: [email protected]<mailto:[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]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, August 06, 2015 2:34 PM To: David Gideon <[email protected]<mailto:[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
