Benchmarking 7.0 performance

[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 will be
saved in less than the blink of an eye.

Of course, learning how to work with SQLite, transfer all that data and
modify your stack will take somewhat longer; but thankfully LC is a rapid
development environment so you can feel good about the fact that it'll take
less time than any other language ;-)

If the thought of learning SQLite seems daunting then working with a NOT
CSV* flat file would also yield noticeable speed increases.



On Wed, Oct 29, 2014 at 9:27 PM, Tim Selander <selander at tkf.att.ne.jp>
wrote:

> 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 is working for me other than saves. And now
> Rinaldi has come to my rescue again. I have use a LOT of his stuff over all
> these years.
>
> Tim Selander
> Tokyo, Japan
>
>
>
> On 10/29/14, 1:57 PM, Kay C Lan wrote:
>
>> On Tue, Oct 28, 2014 at 8:28 PM, Tim Selander <selander at tkf.att.ne.jp>
>> 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 you use
>> to store tab/comma separated values?
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>>
>>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>