I have spent a year plus working on a Lasso/ Filemaker solution. The coding is ok but I find the time to load pages verging on the ridiculous. i.e. 10 secs, 15 secs, 57 secs and 15 secs for 4 separate pages - so every time a user wishes to change an item (they will be changing 30- 40) they are sitting killing time for over half an hour. I have employed progress indicators to disguise the time factor but when you hit the second or third change it starts to get very noticeable. I have scanned the list and followed the advice of minimizing Value List calls and creating layouts that have only the required fields (to avoid FMP sending all the field info) but I'm still hitting this very large speed bump. The only way out of this that I can see is to bite the bullet and go MySql. This leads to lots of newbie fears/questions - any help as always would be appreciated.
1 Just how great a speed increase is My SQL compared to FMP? 2 Filemaker had an easy interface - are there any packages that I can use with MySql to move it towards the ease of use factor? 3 Is there any software that I can use to even partially port my FMP DBs to MySql?
Again thanks for taking time to read this and any suggestions would really be appreciated.
- Alex
-- ------------------------------ Lasso Support: http://support.omnipilot.com/ Search the list archives: http://www.listsearch.com/lassostudiotalk.lasso Manage your list subscription: http://www.listsearch.com/lassostudiotalk.lasso?manage
Sep 04
Bil Corry Re: Change from FMSA to SQL?
Sep 04, 2005; 12:40
Bil Corry
Re: Change from FMSA to SQL?
Sep 04
m i l e s Re: Change from FMSA to SQL?
Sep 04, 2005; 13:03
m i l e s
Re: Change from FMSA to SQL?
Sep 04
Steve Piercy - Web Site Builder Re: Change from FMSA to SQL?
Sep 04, 2005; 15:09
Steve Piercy - Web Site Builder
Re: Change from FMSA to SQL?
Sep 04
Alex McGill Re: Change from FMSA to SQL?
Sep 04, 2005; 15:55
Alex McGill
Re: Change from FMSA to SQL?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!