[ic] fast dictionary searches

James P. Kinney III interchange-users@icdevgroup.org
Thu May 29 18:22:01 2003


--=-j+711EtnYzEJTyxjBi7y
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

I'm trying to implement a fast search on a postgresql database with over
140,000 items. I'm missing something from the docs.

=46rom the Fast Binary Searches:
"The ASCII source file must be ``touched'' to rebuild the index and the
database."

What does this mean and how do I do it? touch
/var/lib/interchange/industrial/products/products.txt.1 will create the
file. It is listed in the dbconf/psql/products.pgsql file to index the
description field.=20

Confusion #2:

I implemented a new component (fast_search) and placed it on a page. It
returns _every_ item in the database. It takes about 60 seconds to build
the page with links to all the other 2000+ pages. Yuck!

[comment]
ui_component: fast_search
ui_type: component
ui_name: fast_search
ui_component_version: 4.9.6
ui_source: templates/components/fast_search


[/comment]
<tr><td align=3D"center">
  <table>
  <tr>
    <td class=3D"categorybar">
      <br>
      <form action=3D"[process href=3Dsearch]" method=3Dpost>
          <input type=3Dhidden name=3Dmv_dict_limit VALUE=3Ddescription>
      <table border=3D"0" width=3D"95%">
      <tr> <td colspan=3D"2" class=3D"categorybar"><font size=3D+1>Fast Par=
t
number search</font></td></tr><tr>
            <td align=3D"left">
              <INPUT MAXLENGTH=3D30 NAME=3Dmv_dict_look type=3Dtext size=3D=
8>
            </td>
            <td align=3D"right" valign=3D"middle" width=3D"45">
              <input type=3D"image" alt=3D"Search Go" width=3D"45" border=
=3D"0"
src=3D"__THEME_IMG_DIR__go.gif">

            </td>
      </tr>
      </table>
      </form>
    </td>
  </tr>
  </table>
</td></tr>

<!-- END COMPONENT [control component fast_search] -->


Suggestions/pointers/documentation are VERY welcome at this point.

Thanks.

--=20
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics) <jkinney@localnetsoluti=
ons.com>
Fingerprint =3D 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7=20

--=-j+711EtnYzEJTyxjBi7y
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQA+1ofJYZCtw4KcbKcRAul6AKCjxDvJ5bfVs4GRA8eAK2CmQ/aawgCgpBmJ
gcljJU0oPvTIKGXCORh7WAU=
=gAPw
-----END PGP SIGNATURE-----

--=-j+711EtnYzEJTyxjBi7y--