Displaying 1 result from an estimated 1 matches for "cast_first_name_20".
Did you mean:
cast_first_name_1
2007 Jun 07
5
Advise on slowness in bootstrapping?
...umns. Some facts first:
Ferret 0.11.4
AAF 0.4.0
Ruby 1.8.6
Rails 1.2.3
Medium table:
105,464 rows
168 columns (mostly varchar(20))
11 actual columns indexed in aaf plus
40 virtual columns indexed in aaf (virtual is concat of two physical columns.
e.g. cast_first_name_1 + cast_last_name_1 through cast_first_name_20 +
cast_last_name_20)
Large table:
1,244,716 rows
same column/index structure
These tables are not updated via Ruby, only read. I am trying to use
rebuild_index to bootstrap the medium sized table and it is taking a very long
time (running for about 4 hours, indicates 50% complete with 4 hours re...