Expected Performance

[B-Man]

I have a general performance question. I am running FMSA 8 on Windows2k3. I am also running lasso 8.5 on Win2k3.

I can do an Inline search and get back 500 records in about 6 secs(Thats Great!), where I am having problems is when I do a nested Inline. I am searching for those 500 records and then updating them 1 @ a time. It updates about 3 records a sec.

Is this about all the speed I am going to get when it comes to updating records?

Thanks for any input.

[inline: -Search,

-Database = 'db',

-Table = 'table',

-UserName = 'name',

-Password = 'pass',

-MaxRecords = 'All',

'job_name' = 'y500629'

]

[records]

[Var: 'key' = (KeyField_Value)]

[Field: 'image_name']

[inline:-Update,

-Database=(Database_Name),

-Table=(Table_Name),

-KeyValue=($KEY),

'part_name' = 's'

]

[/inline]

[/records]

[/inline]

[Livi]

Make sure you use a dedicated FileMaker layout with only the fields you need for the update, so no other fields you don't need for this action.

Livi

[B-Man]

Thanks for the response Livi.

Yep I only have 4 fields on the layout that I am updating. I went from about 15 to 4 fields but did not see any difference in performance.

I spoke with lasso and they said that it should update the records extremly fast. I am going to check my FM server and see if I can do anything there.

Thanks

[Keith LaMarre]

I had a similar problem with speed and it turned out that I resolved it by fixing references - I made certain that all of my references in te filemaker files pointed to the Server's IP Address - I suppose this may be a problem if I ever change this address or move the web publisher to another machine but the change was dramatic.

Edited September 8, 2006 by Guest