At 16:20 29/03/2007, you wrote: >Eduardo Morras <[EMAIL PROTECTED]> wrote: >> Hello: >> >> I'm trying to use altivec simd code to SQLite. Has read hash.c >> but it looks like hashing is done one by one when insert data. >> Is it true? When is called rehash function? If i insert data with >> index i think hashing happens one by one, but if i insert all >> data and after that make an index rehash works. Can anyone confirm >> this? Rehash function is the only one i can convert to altivec >> (with it's own hashing functions). >> > >The hash.c code is only used for some internal housekeeping >details within SQLite. (Symbol tables and that kind of thing.) >It does not come into play when actually executing SQL statements. >SQL data is stored using B-Trees only. No hashing. > >-- >D. Richard Hipp <[EMAIL PROTECTED]>
Thanks D.Richard, i'm trying to speed up the "create index" code and thought that it creates a hash from data and then insert it (the hash/index) in the btree. AFAIK Tree functions (insert, delete, move) cannot be convert to simd, but other code yes. For example in CREATE TABLE tba1 (one varchar(15), two int, three real) CREATE INDEX ind1 ON tba1(one, three) an index ind1 is created. That's where i think a hash is done, ind1=function(one,three) and it can be simd by working with 4(one,three) pairs at same time. Any how, thanks again. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
