I'm seriously considering switching our rather heavy database application
over to FM Server.
But I am a "Proof-of-the-pudding "kind of person and I cannot recommend a
switch based on assumptions such as "I don't see why it shouldn't work".
"Filemaker Inc says this or that ...",
I am convinced that people have already been to where I want to go and I
want to find them and hear what they have to say.
I have three main criteria : Users, Files and Processing.
In my mind, these three criteria form a triangle.
I can only switch to FM if the three sides of the triangle are in place
Side 1 : 15-20 users simultaneously, creating, searching, viewing,
modifying records using complex layouts.
Side 2 : Big files :70000 clients, 20000 products, 300000 payments in the
Bigger files : 140000 clients, 40000 products, 1500000
payments in the Archive base
N.B. Users very rarely need to access the archive base. It
is managed by processes, scripts.
Side 3 : User triggered processes, mailmerging, importing and exporting
files, creating reports ..
I have contacted local Filemaker people here in France asking them to point
me towards companies using Filemaker in these conditions.
Up to today we have not found an similar configuration over here, i.e.
15-20 Users + Big Files + Heavy Processing *** simultaneously ***.
We have found companies that have big files, heavy processing but only one
or two users running scripts against the files.
We have found companies that have 30 Users, but medium sized files and
limited processing ... etc.
From my point of view, these are two sided triangles :) and so I am turning
to the group in the quest for my three sided triangle :
Can anyone point me to companies that are using FM in conditions similar to
(or worse than) those I described above ?