FM8 and the web - speed
Posted: Fri Sep 16, 2005 8:03 am
Current version of db FM6.
Hello All,
I have a 15 file db with approx 1,000 records in half the files and 10,000 - 30,000 records in the rest.
The db is relatively complex with quite a few calcs and summary fields and a lot of related scripts between files, particularly finds and sorts.
The client has offices in the UK, USA, France and Australia. There are approx 20 people per office.
The client wants a web based system which will be common to all offices. As a test we tried access on the current database (hosted on server running FM server). based in the UK, from the US offices. Not suprisingly it was very slow.
I know this is a hell of a big question, but is FM8 Web Publishing fast enough for this? Sorry to sound blasphemous but is it like a 'real' web database application?
Many thanks
Dave
Hello All,
I have a 15 file db with approx 1,000 records in half the files and 10,000 - 30,000 records in the rest.
The db is relatively complex with quite a few calcs and summary fields and a lot of related scripts between files, particularly finds and sorts.
The client has offices in the UK, USA, France and Australia. There are approx 20 people per office.
The client wants a web based system which will be common to all offices. As a test we tried access on the current database (hosted on server running FM server). based in the UK, from the US offices. Not suprisingly it was very slow.
I know this is a hell of a big question, but is FM8 Web Publishing fast enough for this? Sorry to sound blasphemous but is it like a 'real' web database application?
Many thanks
Dave