[FX.php List] Re: Performance hit for unpopulated fields on

[Someone]

Hi Jonathan,
Maybe your data structure should be setup differently
My Java teacher said that any scenario coule be look like a class.

Could you set up a table with field names "table" and "field"
This way your not confined to fields on a layout

Just an idea

Frank

On Aug 27, 2007, at 5:11 PM, fx.php_list-request at mail.iviking.org wrote:

> Hi Folks,
>
> I'm working on a project where I will allow clients to build their
> own fx.php powered web pages by having them selecting from a list of
> available fmp fields in a database.  In order to provide flexibility,
> there might be twice as many fields on a layout than the user might
> select.  The system will then build the fx.php page from the selected
> fields. The unused fields would remain on the layout.
>
> The question I have is regarding the performance hit.  If the unused
> fields remain on the layout, but stay unpopulated (no data), would
> the performance suffer?
>
> Just out of curiosity, would this same scenario cause a problem in  
> MySQL?
>
> Thanks,
>
> Jonathan