Re: Question about a data structure

..oO(Arjen)

I had to do the same thing for a project im working on. Worst case I had
to join 10+ tables on the fly with more then 10k entries. Performance
was terrible so I join the data overnight and dig in the large pool of
data with a simple select :-)

10k entries are _nothing_ for a database, which is able to handle
millions of records. Even a join over 10+ tables shouldn't be much of a
problem, except maybe on a real high-traffic site. Are you sure the
tables were properly indexed? That's one of the most important things.
If every constraint or join requires a full table scan because of
missing or improperly defined indexes, then of course the performance
will be very poor.

Micha
.

Relevant Pages

  • Re: Question about a data structure
    ... Michael Fesser schreef: ... to join 10+ tables on the fly with more then 10k entries. ... Performance was terrible so I join the data overnight and dig in the large pool of data with a simple select :-) ...
    (alt.php)
  • Re: Question about a data structure
    ... Arjen schreef: ... Performance was terrible so I join the data overnight and dig in the large pool of data with a simple select :-) ... worst case I need to join 43 tables with 200k+ entries per table. ...
    (alt.php)
  • Re: no name resolution on local domain
    ... In my limited experience, I have noticed that dig doesn't use the ... /etc/resolv.conf and /etc/host.conf files, but ping does. ... Check resolv.conf and make sure you have these entries: ...
    (comp.os.linux.networking)
  • Re: Control panel
    ... You could dig around in the Registry to remove these entries, ... freeware maymake the job a lot simpler: ...
    (microsoft.public.windowsxp.help_and_support)