Re: [sqlite] Using the static lib of sqlite3 under 64 bit ubuntu

On Mar 29, 2009, at 10:01 PM, Danny De Keuleneire wrote: > Settings: > > Gcc 4.3.3 > Added usr/lib64/libsqlite3.a > > Error: > > Undefined reference to 'pthread_mutex_trylock' > > What I am missing? -lpthread -ldl ___ sqlite-users mailing list

Re: [sqlite] creating unique data takes many hours, help

Hi Michael, Two thoughts -- and I hope others will chime in if I'm off-base here: 1) Build just one index after the import: >From page: http://www.sqlite.org/lang_createtable.html "The UNIQUE constraint causes an unique index to be created on the specified columns." I think that if you

Re: [sqlite] creating unique data takes many hours, help

Michael: While my answer isn't strictly limited to sqlite, the performance nut in me can't help myself. You have a a table with only one column, a string. I could be wrong here but it seems like you just want to keep a list of values that you have already tried. After you insert a bunch of

Re: [sqlite] creating unique data takes many hours, help

Yes, you're right, but if the data is already in index order, you'll do less I/O when creating the index. Whether the sort + create DB time is less than "create DB from random input" time is another question. Jim On 3/29/09, mrobi...@cs.fiu.edu wrote: > question: > When

Re: [sqlite] creating unique data takes many hours, help

Thanks very much. I will try different values for the loops until a get an optimal number, and I will try the "PRAGMA cache_size = <#pages>". command. question: When you say > 2)Sort your input file on the PRIMARY KEY > or on some other INDEX I thought that while sqlite inserts the

Re: [sqlite] creating unique data takes many hours, help

On Sun, 29 Mar 2009 15:19:00 -0400 (EDT), mrobi...@cs.fiu.edu wrote: >Hi, > >I am new with sqlite, and I create a program that reads several mllion >records and puts them into a sqlite db using. > >The table has one column ONLY indexed and unique, but it takes many hours. > >Is it necessary to

[sqlite] Using the static lib of sqlite3 under 64 bit ubuntu

Settings: Gcc 4.3.3 Added usr/lib64/libsqlite3.a Error: Undefined reference to 'pthread_mutex_trylock' What I am missing? If I use the so shared lib no problems at all. Tx, Danny ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] select by min di

"baxy77bax" wrote in message news:22767988.p...@talk.nabble.com > hi , > i need help with this one : i have a table with 2 columns C1 & C2: > > C1 C2 > > a 1 > b 1 > b 2 > b 4 > c 3 > v 2 > c 5 > d 5 > > and i need to get this: > > C1 C2 > > a 1 > b 1 > c 3 > d 5

[sqlite] select by min di

hi , i need help with this one : i have a table with 2 columns C1 & C2: C1 C2 a 1 b 1 b 2 b 4 c 3 v 2 c 5 d 5 and i need to get this: C1 C2 a 1 b 1 c 3 d 5 v 2 so a unique set of data in column C1 where C2 is the min id for that data ? thank you ! -- View this message

Re: [sqlite] sequential row numbers from query

Possible limitations of temporary tables vs views: 1) Temporary tables are static - views are dynamic - i.e. anytime a change is made to the database the temporary tables might need to be recreated. 2) Memory: Temporary tables will be retained in memory until dropped. Views will only use