LiveCode and SQLite performace
Kay C Lan
lan.kc.macmail at gmail.com
Wed Jul 22 05:48:14 CEST 2015
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.
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the use-livecode