LiveCode and SQLite performace

[Kay C Lan]

An example of half a dozen records please. Maybe a couple of very short, a
couple of the longest and a couple of average.

How big is the db file size - MB not record count?

On Wed, Jul 22, 2015 at 7:55 AM, Michael Doub <mikedoub at gmail.com> wrote:

> I need some database consulting help.   I have created an SQLite database
> that has 4 fields:
> ID, URL, tag, local.   IS is integer, unique, URL is text not null unique
> and tag and local are just text.   I have 600,000+ records. I use the ID to
> access each record in most cases or I am filtering trying to find records
> based on the contents of the tag, URL or local fields.
>
> It seems to take forever to open the database.  This is normal?   I am
> primarily using the database to make sure that I do not have non-unique
> URLs, adding performance and selects seem reasonable.   I am just surprised
> about the open performance  Does opening the database load a lot of
> information into memory thus the long delay?   Could I have created the
> database in someway that is not optimal, thus causing the delay?
>
> This is not a livecode issue as I am seeing the same delay when I open the
> database with sqlitebrowser.
>
> Any advise or incites in how sqlite actually works would be appreciated.
>
> Regards,
>    Mike
>
>
> _______________________________________________
> 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
>