Re: [sqlite] [FTS3] Understanding the Flow of data through the tokenizer

On 07/24/2011 08:16 PM, Abhinav Upadhyay wrote: > Hi, > > I am trying to write my own custom tokenizer to filter stopwords apart > from doing normalization and stemming. I have gone through the > comments in fts3_tokenizer.h and also read the implementation of the > simple tokenizer. While overall

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

Very odd, with the "UseSqliteStandard" property enabled, that error message should not be possible. How are you compiling the SQLite.Interop project? When you compiled the System.Data.SQLite assembly, did you use the real MSBuild (i.e. not XBuild)? The command line I gave you would have

Re: [sqlite] SELECT query first run is VERY slow

ANALYZE lasted for ~ 15 minutes. 24 июля 2011, 17:21 от Tito Ciuro : > Hi, > > It has worked fairly well with small databases, but I see the problem with > medium to large files. Have you tried to run ANALYZE on your database? I'm > curious to know how long it takes. > > --

Re: [sqlite] Selected string differs to Inserted one

Hello Andrew, I convert all my strings the UTF-8 before insert or selecting. You probably need to look into something like that too. Filenames for the DB files have to be UTF-8 too or you'll have problems opening files sometimes. My test folder has an umlaut in the path so, this code gets

Re: [sqlite] Selected string differs to Inserted one

On Sun, Jul 24, 2011 at 4:39 PM, Andrew Leeder wrote: > I have a table with a TEXT field that does not return the same string that > was inserted. The character that misbehaves is Greek letter "Ø". In fact > any character from the high end of the ANSII or ASCII table

[sqlite] Selected string differs to Inserted one

Dear All I am very new to SQLite and am trying to convert a Windows Forms C#.NET (VS2010 SP1) application from an Access database to an SQLite one. All seems to have gone extremely well but I have come across one problem that has held me up for several days now. I have a table with a

Re: [sqlite] SELECT query first run is VERY slow

Hi, It has worked fairly well with small databases, but I see the problem with medium to large files. Have you tried to run ANALYZE on your database? I'm curious to know how long it takes. -- Tito On Jul 24, 2011, at 8:26 AM, Григорий Григоренко wrote: >> >> Perhaps my post dated Aug. 19,

[sqlite] [FTS3] Understanding the Flow of data through the tokenizer

Hi, I am trying to write my own custom tokenizer to filter stopwords apart from doing normalization and stemming. I have gone through the comments in fts3_tokenizer.h and also read the implementation of the simple tokenizer. While overall I am able to understand what I need to do to implement

Re: [sqlite] System.DllNotFoundException: SQLite.Interop.DLL

Thanks Joe but no luck. I tracked down the folders that are referenced by LD_LIBRARY_PATH in the Linux OS and copied in SQLite.Interop.DLL into it with no luck. >>MSBuild System.Data.SQLite.2008.csproj /t:Rebuild /p:UseInteropDll=false /p:UseSqliteStandard=true I then created the dll as above

Re: [sqlite] SELECT query first run is VERY slow

> > Perhaps my post dated Aug. 19, 2009 will help a little bit: > > http://www.cocoabuilder.com/archive/cocoa/242954-core-data-dog-slow-when-using-first-time-after-boot.html > > -- Tito > Thanks for sharing. "warming file" is a way to cache whole database as I understand it. After