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 <miked...@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode