7 Replies Latest reply on Feb 27, 2013 10:23 PM by LyndsayHowarth

    Web Based Solution??


      Hey all,

      I'm the sole developer of the student information system in my region of 3 charter schools and a regional office. About 100 different users login each day, for a total of about 1000 log ins a week.

      I am almost constantly getting bombarded with requests for information this question: When will our database be web-based? They think it will be faster on the web, if we're not using FileMaker Client.


      What do I tell them? I've been told by a few people to avoid the current internet capability. But they're putting pressure on me to solve this problem, the problem being slow processessing of data. Now in my defense, I have done almost all I can to offload huge processes to the server through nightly updates. ALmost every field one sees on any page is simply a number or text field that has been updated while they sleep. The connection at the 3 schools is slow because there are 50+ at each school using the one internet access. And my file is hosted somewhere far far away.


      So what should I tell them? Should I delve into learning how to write web pages, duplicating this interface in html and figuring out how to get my website to connect to the FM file? Do I explore the IWP versions?


      Please let me know what i should say to them. Do other clients complain about how the client Filemaker is not nearly as fast as a databse on the web?


      We use an external gradebook and assessment system that is all web-based. They, i think, feel the difference in speeds, and are disliking how slow my solution goes.


      Any thoughts would be appreciated.

        • 1. Re: Web Based Solution??

          Getting into web publishing won't solve the performance issue.


          Tell them they've made a choice to go with the FileMaker platform. That gives them certain disadvantages, namely slower performance than a web-based solution, like PowerSchool. But it has advantages, namely, the cost of a single developer working part-time who can make customizations on the fly.


          Let's talk tomorrow offline.



          1 of 1 people found this helpful
          • 2. Re: Web Based Solution??

            I agree...trying to do what you can do in FileMaker quickly and easily would take 4-10 times longer to develop in a web-based application...and require a team of people to likely get the same functionality you've been able to build with FileMaker. You should do all you can to optimize your application, your remote server, and minimize the amount of network traffic required to be used by the solution.

            • 3. Re: Web Based Solution??

              Thanks DJ and Tim. I forgot about the customization aspect. Every layout and script is tailored to the unique needs of the 3 schools and central office that access the information. I'll make it clear that nothing already out there could do what it needs to do for our schools.

              Maybe in the future there will be something. but for now, I'll do what i can to speed it up.

              Thanks all

              • 4. Re: Web Based Solution??

                Jeremy, I am involved in a similar school situation. Although I don't run the hosts (many throughout the state), the speed issue is pretty much under control, using Terminal Services, which only sends screen information to the user. Local printers can be configured in this scenario, too.


                I started to develop a custom web solution (FM 11), but backed off because of the potential load, printing hurdles, and tricky entry with record-level security.


                - paul

                • 5. Re: Web Based Solution??

                  Who is hosting your database?  If you are running the server, you should be able to use PHP Site Assistant to create web based access to your FM solution.  If you are using a commercial Filemaker centric host, ask them about assistng you.   There is a very good paper in TechNet Documents section on this topic:  techbrief_fm_webpub_en.pdf


                  However, as Paul pointed out, restricting access to FM Pro client elimnates a lot of problems in regard to access, printing, UI and other issues.  From what you've written, it seems the problem is not so much with having to use the FM client for access but the speed of performance over the WAN.


                  In regard to WAN performance, which version of FM are you using?  FM12 has been redesigned to work much faster over the WAN than previous versions.


                  Regardless of version, have you maximzed your schema for WAN performance?  The manner in which you flow amd store data has a tremendous impact on remote access speed. Mark Richman of Skelton Key has delivered talks on this at the last few DevCons.  There is a video he developed in Technical Resource Center that can be downloaded via mrichman_WAN_performance.wrf.zip

                  You will need a WebEx player to view the video file - but download is free if you don't already have it.


                  I personally benefited greatly from taking an online course Mark conducts on this topic.  As I recall the enrollment fee is around $300 - and I found this a bargain as it basically consisted of Mark's providing one on one support to me as we worked through problems in my database design.  I believe he still does these peridocially and you might want to check out the Skeleton Key website for more information. 

                  • 6. Re: Web Based Solution??

                    I may check out Skeleton Key.

                    The issue is that there are still slow parts, and apparently if there's a slow part here and there, they want to abandon the client model. I've met with them and explained the limitations, the status of where we are at, etc. I'm going to do some testing with clients. I'll visit them in their rooms and watch them do their thing with FileMAker and see what happens.

                    thanks for the ideas all.

                    • 7. Re: Web Based Solution??

                      Hi Jeremy,


                      I don't agree here with Tim & David...

                      I think that if you are offering the web-based solution for the other systems that web-based FM solution should be similarly available. They simply are faster! They do not dictate platform (ie Mobile platform). They can be more easily integrated into a single cohesive interface... many reasons!


                      Your problem is the learning curve or the cost of outsourcing to do that. Time or Money... that is their decision. Do we wait for the FM solution to do it's thing? Do we wait until Jeremy is proficient enough to do the PHP and CSS and JS etc to build the web interface? or Do we bite the bullet right now and pay for the web development? I am betting that the last solution is the one they really should be taking and that will save them time and money in the long-run. Customisation is so much easier dynamically on the web.


                      - Lyndsay