Re: Simple PHP/pgsql optimization question...

On Sat, 18 May 2002, [iso-8859-1] Gatan de Menten wrote:

> Hi there all,
>
> First, I'm far from being a professional programmer in pgsql and PHP and I'm
> new to this list, so please pardon if this question seems stupid to you.
>
> In my 'projects' tables, among many other fields, I need a 'license' field.
> I need to optimize the display of the list of all projects (+-200 projects
> to display).
> Which solution do you think would be the fastest, and how much faster?
>
> 1) Have a 'license' table (with and id and a name field) listing all the
> possible licenses and have a foreign key in my 'projects' table pointing to
> that 'license' table.
> the query would look like this:
> select ..., license.name as license from projects, licenses where
> projects.license=license.id and ...
>
> 2) Have the license field in the 'projects' table be a varchar field and
> store the name of the license directly.
>
> 3) Have the license field be an int and have an array in PHP listing all the
> licenses.
>
> 4) another solution?
>
> I personnaly prefer the first solution since it's the cleanest to my eyes
> but I'm ready to trade that for speed, if another solution is much faster.
>
> Thanks a lot,
> Gatan.

I prefer the first solution also. You can add or take away liscenses
without having to edit a huge amount of data. Be sure you do the right
thing with the foreign key. I would leave most of the data handling to
postgresql and use php to make it accessable(sp?) in a
pretty way....

-Chadwick