What is taking the most time ?????

[Steven Cappiello]

I've hosting a database on FM Server 7 over a fast network..

The database only has about 1000 records in it. But, it has about 12 tables, most of which have fewer than 30 fields, however, the main table has about 300 fields in it... plenty of which are calculated fields.

I have a startup script which detects which user is logging on, and then does a find to find the recrords that person is interested in, sorts the records, and brings them to a spreadsheet layout (built in LIST view, it has a few graphics on the layout... (small graphics on each record for little buttons), and a few container fields that I use for highlighting the record..

the problem is that over a realllly fast network, the file takes about 20-30 seconds to load.

I only have one or two users connecting at a time

The server computer is a dual 2Ghz G5 and that's the only file it's hosting (for the most part).

Could someone please tell me what aspects of the solution might be causing the hang at startup ??

When the file loads, it seems to get to the layout it's going to , and then it remains blank for a while while everything loads...

would it help if I cut down on the # of fields in the big table.... :? or changed the calculations to stored vs. unstored... :

anything anyone can offer would help.... perhaps server settings.... cache ??

happy thanksgiving to the Yanks..!!!

[Ender]

One thing to check is file references. If there are any old file references, the database will stall a bit while it tries to resolve them (Make sure you are backed up before deleting any, though. It could be messy if you delete a file reference that is still used.)

>>the problem is that over a realllly fast network, the file takes about 20-30 seconds to load.

I only have one or two users connecting at a time

Is it slow just the first time entering this layout, or everytime?

[Steven Cappiello]

Actually... I think there may be an old file reference somewhere.. BUT..... I can't seem to find where the reference is...

it's not a table occurrence... any ideas for how I can go about locating it :

[Steven Cappiello]

ah... I found the way to remove old file references... I've removed a few.. fingers crossed it will help !!

thanks )

[Søren Dyhr]

the main table has about 300 fields in it... plenty of which are calculated fields.

This is not really a hijacking attempt, but this is the second time around today - What is it 'bout databases I don't get. Unstored fields in portal only update in the visible part of the portal, provided that calcfields not are referencing other calcfields. This means that i makes sence to make the live part of the real estate as small as posible. Eventhough the networking scheme has undergone some changes lately, would I guess that by and large is the mentioned issues in:

http://www.aptworks.com/downloads/presentations/PacketWatchingPres_v2.PDF

...still true to some extend.

--sd