Re: Re: A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Richard Gaskin via use-livecode
Tom Glod wrote: > no reason why it wouldn't work... but keep 2 things in mind > > if you use community edition, the number of HHTP Requests you can make > to the same domain at one time is exactly 1. How many are needed from a single client? While it's unfortunate the LiveCode Community Edition

Re: A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Tom Glod via use-livecode
no reason why it wouldn't work... but keep 2 things in mind if you use community edition, the number of HHTP Requests you can make to the same domain at one time is exactly 1. For a system like this, it could be better to save to an sql because seperate TXT files would be a lot of IO calls. If y

A suggestion for an in-memory database, following up on Richard’s experiment

2018-03-01 Thread Jonathan Lynch via use-livecode
This is a different idea from the other thread, so I am starting a new thread. Imagine the following scenario: Each record is saved as a separate text file. LC loads up all the text files into a single massive global array. LC listens to a port for DB requests. When a DB request comes in, LC