On Tue, 2003-09-16 at 12:59, Jean-Claude Wippler wrote: > Kristian G. Kvilekval wrote:
> > What determines the size of the hash table? > > It's a power of two, and it's always larger than the number of data > rows. I've written a bit more about hashed and blocked views on this > new page: > http://www.equi4.com/mkmapping.html > > -jcw Hmm... that's exactly what prompted the question. I have a database with 4030 entries, but one machine it generates a hash with 4096 and the other with 8192.. Is it checking whether the database fits in memory? Just infinitely curious: ------------ Machine 1: 512KB ram Database Sz: 673725 mk4dump ~/.zinf/db/metadb | fgrep VIEW VIEW 1 rows = dbview:V dbview_H1:V VIEW 4030 rows = url:S type:S title:S artist:S album:S genre:S comment:S track:S year:S VIEW 4097 rows = _H:I _R:I ---------------------------------- Machine 2: 2GB ram Database sz : 689683 VIEW 1 rows = dbview:V dbview_H1:V VIEW 4030 rows = url:S type:S title:S artist:S album:S genre:S comment:S track:S year:S VIEW 8193 rows = _H:I _R:I -- email:[EMAIL PROTECTED] office:(805)893-4276 http://www.cs.ucsb.edu/~kris _______________________________________________ metakit mailing list - [EMAIL PROTECTED] http://www.equi4.com/mailman/listinfo/metakit
