On 23/05/2011, at 11:13 PM, jose isaias cabrera wrote: > SharedDB file is about 600 megs shared over a network drive and it's getting > slow, but if I get the specific record ID only with the select that I want, > it's a lot faster than getting the select with all the items in one shot. > SQLite probably does something in the back ground to get things faster when > addressed specifically to an ID.
600MB and slow seems like a good candidate for better structuring your database. If you post your full schema, we can suggest a better way to structure it for optimal speed and efficiency. Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users