Loading ...
Sorry, an error occurred while loading the content.

51161Re: OT: OO data design and search performance

Expand Messages
  • Perrin Harkins
    Apr 11, 2003
    • 0 Attachment
      On Fri, 2003-04-11 at 05:42, Clinton Gormley wrote:
      > It is clearly possible to build a search which ploughs through all of
      > the tables, but it would be much faster if I had one flat table for (eg)
      > places to stay with all of the attributes in different columns. My
      > original plan was to do just this - use a cron job to rebuild the flat
      > tables when any objects are changed. But this negates the flexibility of
      > the design ie instead of being able to add and remove attributes by
      > altering a single list, I now also need to change the structure of the
      > flat tables and the SQL which accesses them

      The other suggestions offered here sound fine to me, but for a radically
      different take on indexing while keeping flexibility, see XML::Comma

      - Perrin
    • Show all 12 messages in this topic