Need fore speed...

David Bovill david at openpartnership.net
Sat Jul 14 10:18:04 CDT 2007


Interesting.... I read somewhere that Google added full text search to
sqlLite codebase recently (last 6 months)?

On 14/07/07, viktoras didziulis <viktoras at ekoinf.net> wrote:
>
> one more alternative - works very fast - use sqlite in-memory database:
> 1) download sqlite3 command-line executable
> 2) run shell (cmd on windows) and create an in-memory database by
> executing:
> sqlite3 :memory:
> 3) assuming your data consists of 4 fields (columns) that are tab
> delimited and stored in file table.csv type or copy paste and execute
> the following commands in your sqlite3 session:
>
> create table myTable (a varchar, b varchar, pepMass float, d integer);
> .separator \t
> .import table.csv myTable
>
> 4) Now all you need to do is to store a list of update statements like
> this in text file (lets name it q.sql):
> UPDATE myTable SET  a='whatever', b='whatever',  d='100' WHERE pepMass
> BETWEEN   2267.0000 AND 2267.9999;
> UPDATE myTable SET a='whatever', b='whatever',  d='1000' WHERE pepMass
> BETWEEN   2268.0000 AND 2268.9999;
>
> and
> 5) execute the following sql string in sqlite:
> .read q.sql
>
> 6) Thats it. Now you can get your result:
> .output myTable.csv
> SELECT * FROM myTable;
> .output stdout
>
> Here you can use Revolution to create a list of multiple UPDATES :-).
> But I do not know how to use in memory sqlite database directly from
> Revolution :-(.
>
> Viktoras
>
>
> .
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>



More information about the use-livecode mailing list