Re: Speed of locating tables?

Hi,

Steve Wampler:
> So, to refine the question - given a DB with (say) 100,000
> tables, how quickly can PG access a table given its name?
>
You will then have a directory with one hundred thousand entries (plus
one for each index you decide to create). This will slow down your
system like hell.

> Thanks! I'm also open to suggestions on other ways to
> represent the data that would provide better access
> performance -
>
Easy. Every table gets another column "telescope_ID", and you create
a new table which maps from the csope's ID to their name and vice versa.

> you can probably tell I'm new to the world of databases.

You definitely want to read an introductory book / online article about
the subject.

--
Matthias Urlichs | noris network GmbH | smurf(at)noris(dot)de | ICQ: 20193661
The quote was selected randomly. Really. | http://smurf.noris.de/
--
There are those who argue that everything breaks even... I suppose
that because the rich man gets ice in the summer and the poor man
gets it in the winter things are breaking even for both.
-- Bat Masterson