The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Freezing when using moderately sized data sets
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

mchemistry

Canada
2 Posts

Posted - 09/30/2015 :  5:37:51 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Using OriginPro 2015 SR2 64-bit on Windows 7 system.
Hi folks, first time posting to this forum, not the first time perusing through it, thought someone might be able to explain to me my issue, even better if they can offer a solution.
I'm working with a moderately large data set on the same worksheet. 1300 Columns, 20 Rows. When I try to carry out simple operations (such as deleting 500 columns reducing the number to 800), the application will freeze up until complete. This will take several minutes. The system itself is not taxed for resources at all, <20% CPU use, less than that in RAM and page file size. Nothing that would typically suggest a freeze up would be happening. Could you suggest a reason why the application is freezing up, is there a need to manually allocate resources to it ? Any pointers, heck even anecdotes that resemble possible solutions would be appreciated as this issue is really killing my efficiency.

Hideo Fujii

USA
1582 Posts

Posted - 10/01/2015 :  2:01:16 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi mchemistry,

I'm sure Origin is doing some "house work" during the process. I have tried some
experiments to delete 500 columns (column 101-600) in a worksheet with 1300 columns:

// 1) Delete column by column
for(ii=101; ii<=600; ii++) {
  range rc=[Book2]1!col(101);
  delete rc;
}
//==> 337 seconds

// 2) Delete a block of columns
range rd = [Book2]Sheet1!101:600;
delete rd;
//==> 172 seconds

// 3) Copy columns (then delete original workbook)
wrcopy iw:=[Book1]sheet1! c1:=1 c2:=100 label:=1 ow:=[Book2]sheet1!;
wrcopy iw:=[Book1]sheet1! c1:=601 c2:=1300 dc1:=101 label:=1 ow:=[Book2]sheet1!;
//window -cd Book1; //delete original workbook
//==>0.375 seconds

// 4) Hide instead of delete columns
colhide irng:=col(101):col(600) operation:=hide;
//==>0.015 seconds

So, I suggest you to copy the necessary columns to a new worksheet (then delete the original),
or if you simply don't want to view the unnecessary columns, you can hide them.

--Hideo Fujii
OriginLab
Go to Top of Page

mchemistry

Canada
2 Posts

Posted - 10/01/2015 :  3:17:46 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
OK well I'll give that a go. Thank you very much for taking the time to look into it.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000