Jump to content
Sign in to follow this  
mr_vodka

Speed of Globals verses Preferences Table

Recommended Posts

Ok my brain is having one of its many moments again...

Once there was a thread posted on here regarding the speed of storing data in global fields verses creating a cartesian join to a preferences tables from each table. It mentioned the way it came over the network and that it may be faster to have the preferences table because it would be stored on the computer rather than having to come over the network each time with globals.

I cant for the life of me remember where it was...

Share this post


Link to post
Share on other sites

There is something even faster:

http://www.filemakermagazine.com/videos/using-global-graphic-variables.html

...only you need to be subscriper, to pick his brains on this one!

--sd

Share this post


Link to post
Share on other sites

Hi Soren,

Yes I did read that article a while ago. I am a subscriber and I try to read all of Matthew's articles. Thank you for pointing to it anyway. However, I was specifically looking for that thread. I thought that Mike Hackett had orig posted it but alas I could not find it.

Share this post


Link to post
Share on other sites

This is the only thing I could find of mine:

http://fmforums.com/forum/showtopic.php?tid/181666/post/227154/hl/faster+loop/

Which is about using variables vs. global fields. Not exactly what you were looking for.

I should think editing values in regular fields would be slower than editing values in global fields, since regular fields are stored on the host and must go through record locking phases when the data is changed.

Share this post


Link to post
Share on other sites

There are even more to the topic, remember when Debi Fuchs examined the swiftness in illegal relations (global to global) under fm5??? We can today remove any indexing with cathesian linking to dummy fields and the remove them on both sides later, to prevent any indexing being thrown around unnessersary.

http://www.kevinfrank.com/download/df_invalid_relationships.zip

--sd

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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