Performance issue in multiple files over Custom web publishing

[Deepak Kumar]

hi forum,

Scenario: I have 9 FileMaker files, each of 1 table, related to each other. I have made custom web publishing through PHP.

Problem: Performance is very slow over net.

Can you all suggest the exact problem?

[webko]

What is on the layouts you are addressing?

How much data is actually being returned from queries?

[Deepak Kumar]

Data is retrieved from 4 files( tables).

[webko]

Within the context of the API, which tables are addressed is not all that important. It's what is on the actual layouts being called that is important, as that determines which fields of data are returned.

If, for example, you have a table with 1000 fields but you only need the data from one of them, it is extremely inefficient to use a layout that has all 1000 fields on it - the data from all of them will be returned, even if you only display one of them.

This the question about how much data is being returned - you can get an idea by using a command like:

print_r($yourdataSet);

To see the full data set coming back.

[Deepak Kumar]

dear webko,

I have a layout where the data is coming from 4 files where each file(table) has 500+ fields. Only few of the fields are used in each of the table.

My question is that: is there any problem of internet speed or multiple file.

Will i able to enhance the performance by merging all the files in one ?

[Deepak Kumar]

Thanks webko.

Got ur point and implemented it. Now the performance has enhanced.