Jump to content

Expected Performance


This topic is 6474 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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]

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 6474 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.