Sqlite and performances in LiveCode

[Web Admin Himalayan Academy]

On 3/5/12 12:53 PM, � wrote:
> Your "acid test" is very interesting. Using sqlite3 directly is one solution to increase performance of LiveCode.
>
> And you're right, a response time of less than a second is acceptable from a user's perspective and and limit the number of registration is a way to reach this "performance".
Also the method you use for displaying records in a field is important. 
Perhaps you already know this:

Never push your data to the field one line at a time. Build a var with 
results first and then put the var into the field.