Jump to content

make unstored calculation-rendered images show up faster ?


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

Recommended Posts

Hi,

I've gone a bit crazy building some pretty interface stuff... for example, red, green and yellow lights that show up on a record based on unstored calcs... unfortunately, when the script changes the value of the calc by setting a field, the images change somewhat sluggishly.

I know I'm not providing specifics, but could someone talk to me a bit about what, in general, can speed up such responsiveness...

for example:

- the size of the bitmap image I'm using... e.g. 5k vs. 50k ?

-whether it's in a global in the same table versus pulled from a related image table ?

-whether some of the calcs the unstored calcs are based on are indexed at the "none" vs. "all" setting ?

-having too many fields in the table, even if they don't show on the layout.. like over 200 fields in the table (it's one of my first databases that originated well before I fully understood normalization) ?

-is "commit record" a slow-down when inserted into scripts.. ?when is it necessary ?

Re-writing the whole database is impossible as it's heavily in use now.. I'm just hoping for some ways I might be able to speed things up... things to look for etc..

I downloaded a demo of Inspector and it found plenty of Missing Fields however they're not used on the layouts and scripts that I'm referring to.. can they affect speed even if they're not on the same layouts and main tables?

Link to comment
Share on other sites

It shouldn't matter how many total fields or records are in the table, and it shouldn't matter where the global images reside.

I think the biggest factors are:

•Image file size

•Unstored vs. stored calc. Stored will be faster

•Network speed between client and host

•Computer hardware (CPU speed, RAM, video card)

So optimizing those things would help.

Link to comment
Share on other sites

I would also recommend that you optomize your file - compact and the other one.... i forget what it's called but that one. One of my DB's has a few hundred thousand images stored as references and it starts getting a bit sluggish every few months - file opt does a good job of speeding everything up again though.

Link to comment
Share on other sites

thanks Ender and Genx

some of the calcs have to be unstored because i need them

to react instantly to changes in parameters.. I'll see about reducing file size of the images... but I think at least one of them is quite small already...

i'm set in these areas:

•Network speed between client and host

•Computer hardware (CPU speed, RAM, video card)

Link to comment
Share on other sites

This topic is 6113 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.