I've created a value list that serves as an email autocomplete drop down (like the sort in an email client). This VL looks to a single text field in a single record table which currently has 3000 lines. The field is updated every 15 minutes by a scheduled server script.
The 'auto complete using value list' option is applied on the field that refers to this VL.
The old method was to not have a VL but to just tick the 'auto complete using existing values' option on the field. This was not ideal because existing values might be incorrectly spelled email addresses (and the user would not be able to remove them).
Since switching to the new method it is slower to retrieve the values from the VL. It is not the type of slowness that locks up filemake; rather it just means the user has to wait 1-4 seconds for values to pop up when letters are typed - before this is was instant in the way it is instant in normal email clients.
Does anyone have any ideas as to how to speed it up? Or whether this is expected from a single field VL?
I'm new to FMS and I'm trying to figure out why opening a database is taking so long. When I open the DB over our gigabit LAN things work smoothly and the layout opens in 1-2 seconds, but if I switch to our Wireless LAN opening the same layout can take up to 90 seconds and if I try to connect via VPN from home then we're into the minutes time frame. All the calculations occur server side in FMS correct? So if it's sending the same amount of results data why does a drop in connection speed cause such a drastic change in load times, unless of course wer're sending a HUGE amount of data to the client. Is there a way to track how much data is getting sent to the client?
The size of the database is really quite tiny; something like 200k records / 3k fields.
2x 2.93 Ghz Hexcores
16GB of 1333 Mhz DDR3 ram.
The only application it runs is FMS though it does alos serve a file store.
The CPU according to Activity Monitor never gets above 1-2% usage.
I'm wondering any of you could shed some light on this for me or rather make some educated guesses about what could be our problem!
Mac server (10.6.8), running FileMaker Server 11 Advanced
Mac clients (all between 10.5.8 and 10.6.8 I think) all running via FileMaker Pro 11 - these clients log into networked user accounts which are synched between 2 different locations (although they only log into this FileMaker Server from one location)
We also have a number of clients who connect to a PHP site with FileMaker backend.
Right so at least once a week our server crashes, all users get the spinning wheel and are kicked or have to force quit FileMaker. There is nothing at all in the logs to suggest what has caused this...
I just wanted to know if there is some kind of issue with our setup i.e. the synched networked user accounts or if there is anything else any of you can suggest???
If you want some more info don't hesitate to ask!
Thanks in advance