Re: Benchmarking 7.0 performance

2014-10-30 Thread Tim Selander
Thanks, Kay! Rinaldi's plug in has "saved" me with the saving problem -- it also seems a little slow on the saves, but does it in the background with no visible impact/slowdown while using the stack as it saves. Good enough for our needs. I hear you on the merits of SQLite. But my main goal

Re: Benchmarking 7.0 performance

2014-10-30 Thread Kay C Lan
Sorry, hit the Send button accidentally before finding the link. NOT CSV* * For reasons as to why you wouldn't use a comma to separate your values, please refer to this excellent article by Richard Gaskin: http://www.fourthworld.com/embassy/articles/csv-must-die.html Unfortunately, using 1 Card

Re: Benchmarking 7.0 performance

2014-10-30 Thread Kay C Lan
So you are saying that there is NO difference between 6.5 and 7.0, both take 10-12 sec to save your file. Are you still looking for a way to speed that up? If so the short answer is you need to move all those records to an SQLite database. 1 card + 1 SQLite DB and guaranteed any changes you make

Re: Benchmarking 7.0 performance

2014-10-29 Thread Tim Selander
Hi Kay, Good question! Wait a moment OK, I'm back. Under 6.5 it also takes about 12 seconds. It is a data stack in the old HC sense, not SQL or even CSV. It is about 11,000 cards, each containing the customer's address & other info. !0.2MB total file size. I am pleased with how fast it

Re: Benchmarking 7.0 performance

2014-10-28 Thread Kay C Lan
On Tue, Oct 28, 2014 at 8:28 PM, Tim Selander wrote: > saving changes to the file takes a full 10 seconds or more. > How long does it take in LC 6.x ? When you say 'measly 10MB file - customer database. Are you saying the file is a db file like mySQL or SQLite, or is it just a flat file that yo

Re: Benchmarking 7.0 performance

2014-10-28 Thread Tim Selander
Actually, I thought about an autosave. Tried an idler handler -- when 30 seconds of idle time accumulates, I figured that would indicate non-use, and I could execute a save without disrupting work flow. However, I couldn't make it work. Put it in the stack script but the idle handler never seem

Re: Benchmarking 7.0 performance

2014-10-28 Thread Richmond
On 10/28/2014 02:28 PM, Tim Selander wrote: I don't know about benchmark on routines, but I have created a measly 10MB file -- customer database -- and saving changes to the file takes a full 10 seconds or more. That seems pretty slow to me. Duplicating the file in Finder takes a fraction of a

Re: Benchmarking 7.0 performance

2014-10-28 Thread Tim Selander
I don't know about benchmark on routines, but I have created a measly 10MB file -- customer database -- and saving changes to the file takes a full 10 seconds or more. That seems pretty slow to me. Duplicating the file in Finder takes a fraction of a second. Saving an edited 10MB .wav audio fil