Re: [sqlite] large db performance considerations

gt;wrote: > > On 8 Jun 2009, at 4:45am, Paul Perry wrote: > > > The latest content I have added, has over 31,000 records. A basic > > select, > > such as: > > > > Select Content from BookContent where DocumentID = 10; > > takes nearly 15 seconds. Ar

[sqlite] large db performance considerations

Hello, I was wondering if anybody has a tip for optimizing the query time on a table. I have read several web pages about optimizing SQLite queries, but have not been able to come to any conclusions. I have a table: CREATE VIRTUAL TABLE BookContent using fts3( DocumentID INTEGER PRIMARY KEY,

Re: [sqlite] First Program using sqlite3.dll - Linker Errors

Add the lib file you generated with lib.exe into your project. Just pointing to the directory is not enough. That should fix up your link errors. On Sat, Mar 28, 2009 at 10:53 AM, Neil Jeffery wrote: > > Hi All, > > > > I am attempting to write a program which

Re: [sqlite] Formatted text with fts3

lp you figure out an appropriate > approach for this part of the system (for instance, if you decide to > strip tags for other reasons, then it all becomes easy!). > > -scott > > > On Tue, Mar 10, 2009 at 6:56 AM, Paul Perry <paulmjpe...@gmail.com> wrote: &

Re: [sqlite] Formatted text with fts3

Thank you for the pointers Alexandre and Alexey. I spent about 30 minutes looking into the parser, and it looks like it is a possibility. I'll require a more in-depth understanding in order to do this. I would probably start with the simple parser, and go from there. > I think to prepare html

[sqlite] Formatted text with fts3

I've been looking into the full text search capabilities of SQLite and it looks like exactly what I need. Cool stuff, especially in the confines of all the other great features of SQLite. The question is if I could put formatted text in a text field, and not have that show up in a full text