Ways to find cause for page delay

classic Classic list List threaded Threaded
35 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Jonathan Guthrie-3
The FileMaker ODBC drivers are distributed with the FMSA package from what I recall.
Are you using FMS or FMSA? Someone correct me if I am wrong but I'm pretty sure ODBC only comes with Advanced.

On 2012-06-21, at 9:49 AM, Patrick Larkin wrote:

> Has anyone actually done ODBC and Lasso on Filemaker Server 10?  
>
> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's provided ODBC driver on the Filemaker Server and then setting up the Filemaker database accordingly.  
>
> This, however, is the opposite.  I want Filemaker to do be the data source but I don't see any ODBC driver from Filemaker to run on the server so Lasso will see it.  I'm assuming I have to install a driver on the Filemaker Server (other than the MySQL driver used for a solely different purpose) and set it up as a DSN using Apple's ODBC Administrator.  THen I need to tell Lasso about it.
>
> But where is this elusive driver?
>
>
> Patrick
>
> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>
>> Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-slow-tp4016733p4017063.html
>>
>> As far as the IIS timeout, you can change that setting.
>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
>>
>> There's also a hack.
>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>
>> --steve
>>
>>
>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>
>>> Not confirmed to work with 8.6 afaik.
>>>
>>>
>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>> Based on reports, using odbc with FMSA is much faster.
>>>>
>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>> FMS11 on today's hardware.
>>>>>
>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>
>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>> dev server performed better than the Windows server used in
>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>> better with that setup.
>>>>>
>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>> The strange part is that It is roughly 3 times faster on a three server
>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>
>>>>>> The new setup is web server _ Filemaker 10 Server Advanced running on a
>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
>>>> modification to the Filemaker 11 platform.  I expected a marked improvement
>>>> just on horsepower and OS improvements alone!  :)
>>>>>>
>>>>>> Patrick Larkin
>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>> Bethlehem Area School District
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>
>>>>>>> one way to get a look at what's happening throughout your page is using
>>>> some simple timers, however, it sounds like your issues are likely with the
>>>> Filemaker interaction and not within your lasso code.
>>>>>>>
>>>>>>> simple timer:
>>>>>>> get the page start time in milliseconds
>>>>>>>      local('start' = date_msec);
>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>      (date_msec - #start)+'ms';
>>>>>>>
>>>>>>> by comparing the time elapsed from one code block to the next, you can
>>>> see how long each piece is taking and compare results if you experiment
>>>> with different layouts or methods of organizing your data and processing it.
>>>>>>>
>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>> reviewing each layout to make sure you have layouts that use properly
>>>> indexed fields, dont have extra fields on the layout that you are not
>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>> significantly from nested inlines, so you may want to wrap both inlines in
>>>> an outer inline or just simply nest the second inline inside the first (not
>>>> inside the records container ;)  ) and test to see if you get performance
>>>> gains from there.
>>>>>>>
>>>>>>> In addition, you may wish to double check the Filemaker server setup to
>>>> make sure you have allowed enough resources, as the defaults are not
>>>> necessarily good for web interaction.
>>>>>>>
>>>>>>> Tim Taplin
>>>>>>>
>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>
>>>>>>>> Hello -
>>>>>>>>
>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
>>>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
>>>> to track down what the issue might be.
>>>>>>>>
>>>>>>>> The page simply runs one inline to pull student demographics and
>>>> another inline from another database to pull a dozen other fields.  The
>>>> inlines put everything into variables which are then displayed in the page
>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>
>>>>>>>> What are some techniques people use?  I tried moving the [abort] tag
>>>> around but that only gets me so far.
>>>>>>>>
>>>>>>>>
>>>>>>>> Patrick
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>
>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <--
>>>>> Mvh
>>>>> Johan Sölve
>>>>> ____________________________________
>>>>> Montania System AB
>>>>> Halmstad   Stockholm
>>>>> http://www.montania.se
>>>>>
>>>>> Johan Sölve
>>>>> Mobil +46 709-51 55 70
>>>>> [hidden email]
>>>>>
>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>>
>>>
>>
>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>> Steve Piercy               Web Site Builder               Soquel, CA
>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

Jono

----------------------------
Jonathan Guthrie
[hidden email]
LassoSoft Inc.
+1 888-286-7753 ext 708

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Carl Ketterling
That's what I understand.  I have FMSA v11, and I know it has ODBC
ability (although I've never used it).

Carl


In response to this text from Jonathan Guthrie ([hidden email]) sent
on Thursday, June 21, 2012 at 10:10 AM (-0400):

>The FileMaker ODBC drivers are distributed with the FMSA package from
>what I recall.
>Are you using FMS or FMSA? Someone correct me if I am wrong but I'm
>pretty sure ODBC only comes with Advanced.
>
>On 2012-06-21, at 9:49 AM, Patrick Larkin wrote:
>
>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?  
>>
>> I have Filemaker clients accessing MySQL over ODBC by installing
>MySQL's provided ODBC driver on the Filemaker Server and then setting up
>the Filemaker database accordingly.  
>>
>> This, however, is the opposite.  I want Filemaker to do be the data
>source but I don't see any ODBC driver from Filemaker to run on the
>server so Lasso will see it.  I'm assuming I have to install a driver on
>the Filemaker Server (other than the MySQL driver used for a solely
>different purpose) and set it up as a DSN using Apple's ODBC
>Administrator.  THen I need to tell Lasso about it.
>>
>> But where is this elusive driver?
>>
>>
>> Patrick
>>
>> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>
>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso
>Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-
>Publishing-dead-slow-tp4016733p4017063.html
>>>
>>> As far as the IIS timeout, you can change that setting.
>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-
>tp3131750p3131751.html
>>>
>>> There's also a hack.
>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>
>>> --steve
>>>
>>>
>>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>
>>>> Not confirmed to work with 8.6 afaik.
>>>>
>>>>
>>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>
>>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>> FMS11 on today's hardware.
>>>>>>
>>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>
>>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>> dev server performed better than the Windows server used in
>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>> better with that setup.
>>>>>>
>>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>> The strange part is that It is roughly 3 times faster on a three
server
>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker
Server 6)
>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>
>>>>>>> The new setup is web server _ Filemaker 10 Server Advanced
running on a
>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted
without

>>>>> modification to the Filemaker 11 platform.  I expected a marked
>improvement
>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>
>>>>>>> Patrick Larkin
>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>> Bethlehem Area School District
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>
>>>>>>>> one way to get a look at what's happening throughout your page
>is using
>>>>> some simple timers, however, it sounds like your issues are likely
>with the
>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>
>>>>>>>> simple timer:
>>>>>>>> get the page start time in milliseconds
>>>>>>>>      local('start' = date_msec);
>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>      (date_msec - #start)+'ms';
>>>>>>>>
>>>>>>>> by comparing the time elapsed from one code block to the next,
you can

>>>>> see how long each piece is taking and compare results if you experiment
>>>>> with different layouts or methods of organizing your data and
>processing it.
>>>>>>>>
>>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>> significantly from nested inlines, so you may want to wrap both
>inlines in
>>>>> an outer inline or just simply nest the second inline inside the
>first (not
>>>>> inside the records container ;)  ) and test to see if you get
performance

>>>>> gains from there.
>>>>>>>>
>>>>>>>> In addition, you may wish to double check the Filemaker server
>setup to
>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>> necessarily good for web interaction.
>>>>>>>>
>>>>>>>> Tim Taplin
>>>>>>>>
>>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>
>>>>>>>>> Hello -
>>>>>>>>>
>>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.
The page

>>>>> I'm working on loads significantly faster with Filemaker 6(!) and
>am trying
>>>>> to track down what the issue might be.
>>>>>>>>>
>>>>>>>>> The page simply runs one inline to pull student demographics and
>>>>> another inline from another database to pull a dozen other fields.  The
>>>>> inlines put everything into variables which are then displayed in
>the page
>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>
>>>>>>>>> What are some techniques people use?  I tried moving the [abort] tag
>>>>> around but that only gets me so far.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Patrick
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <--
>>>>>> Mvh
>>>>>> Johan Sölve
>>>>>> ____________________________________
>>>>>> Montania System AB
>>>>>> Halmstad   Stockholm
>>>>>> http://www.montania.se
>>>>>>
>>>>>> Johan Sölve
>>>>>> Mobil +46 709-51 55 70
>>>>>> [hidden email]
>>>>>>
>>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>
>>>>
>>>>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
>Jono
>
>----------------------------
>Jonathan Guthrie
>[hidden email]
>LassoSoft Inc.
>+1 888-286-7753 ext 708
>
>#############################################################
>This message is sent to you because you are subscribed to
>  the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Patrick Larkin-2
In reply to this post by Jonathan Guthrie-3
I am using Filemaker Server Advanced version 10.

But I have a license for version 11 if that's what I need.  I don't see anything obviously labeled as an ODBC driver.


Patrick Larkin
Developer/Administrator of Special Systems / Webmaster
Bethlehem Area School District




On Jun 21, 2012, at 10:10 AM, Jonathan Guthrie wrote:

> The FileMaker ODBC drivers are distributed with the FMSA package from what I recall.
> Are you using FMS or FMSA? Someone correct me if I am wrong but I'm pretty sure ODBC only comes with Advanced.
>
> On 2012-06-21, at 9:49 AM, Patrick Larkin wrote:
>
>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?  
>>
>> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's provided ODBC driver on the Filemaker Server and then setting up the Filemaker database accordingly.  
>>
>> This, however, is the opposite.  I want Filemaker to do be the data source but I don't see any ODBC driver from Filemaker to run on the server so Lasso will see it.  I'm assuming I have to install a driver on the Filemaker Server (other than the MySQL driver used for a solely different purpose) and set it up as a DSN using Apple's ODBC Administrator.  THen I need to tell Lasso about it.
>>
>> But where is this elusive driver?
>>
>>
>> Patrick
>>
>> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>
>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-slow-tp4016733p4017063.html
>>>
>>> As far as the IIS timeout, you can change that setting.
>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
>>>
>>> There's also a hack.
>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>
>>> --steve
>>>
>>>
>>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>
>>>> Not confirmed to work with 8.6 afaik.
>>>>
>>>>
>>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>
>>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>> FMS11 on today's hardware.
>>>>>>
>>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>
>>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>> dev server performed better than the Windows server used in
>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>> better with that setup.
>>>>>>
>>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>> The strange part is that It is roughly 3 times faster on a three server
>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>
>>>>>>> The new setup is web server _ Filemaker 10 Server Advanced running on a
>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
>>>>> modification to the Filemaker 11 platform.  I expected a marked improvement
>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>
>>>>>>> Patrick Larkin
>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>> Bethlehem Area School District
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>
>>>>>>>> one way to get a look at what's happening throughout your page is using
>>>>> some simple timers, however, it sounds like your issues are likely with the
>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>
>>>>>>>> simple timer:
>>>>>>>> get the page start time in milliseconds
>>>>>>>>     local('start' = date_msec);
>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>     (date_msec - #start)+'ms';
>>>>>>>>
>>>>>>>> by comparing the time elapsed from one code block to the next, you can
>>>>> see how long each piece is taking and compare results if you experiment
>>>>> with different layouts or methods of organizing your data and processing it.
>>>>>>>>
>>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>> significantly from nested inlines, so you may want to wrap both inlines in
>>>>> an outer inline or just simply nest the second inline inside the first (not
>>>>> inside the records container ;)  ) and test to see if you get performance
>>>>> gains from there.
>>>>>>>>
>>>>>>>> In addition, you may wish to double check the Filemaker server setup to
>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>> necessarily good for web interaction.
>>>>>>>>
>>>>>>>> Tim Taplin
>>>>>>>>
>>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>
>>>>>>>>> Hello -
>>>>>>>>>
>>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
>>>>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
>>>>> to track down what the issue might be.
>>>>>>>>>
>>>>>>>>> The page simply runs one inline to pull student demographics and
>>>>> another inline from another database to pull a dozen other fields.  The
>>>>> inlines put everything into variables which are then displayed in the page
>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>
>>>>>>>>> What are some techniques people use?  I tried moving the [abort] tag
>>>>> around but that only gets me so far.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Patrick
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <--
>>>>>> Mvh
>>>>>> Johan Sölve
>>>>>> ____________________________________
>>>>>> Montania System AB
>>>>>> Halmstad   Stockholm
>>>>>> http://www.montania.se
>>>>>>
>>>>>> Johan Sölve
>>>>>> Mobil +46 709-51 55 70
>>>>>> [hidden email]
>>>>>>
>>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>
>>>>
>>>>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> Jono
>
> ----------------------------
> Jonathan Guthrie
> [hidden email]
> LassoSoft Inc.
> +1 888-286-7753 ext 708
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Patrick Larkin-2
In reply to this post by Carl Ketterling
Yes, even version 10 has all the ODBC settings in the admin control panel.  Just a matter of setting up the ODBC driver.  I just found a driver on the install disc but it's labeled "Client Driver" which implies to me that it is installed on a client to share a database with Word or Excel or something.  I'll give it a whirl.


Patrick


On Jun 21, 2012, at 10:13 AM, Carl Ketterling wrote:

> That's what I understand.  I have FMSA v11, and I know it has ODBC
> ability (although I've never used it).
>
> Carl
>
>
> In response to this text from Jonathan Guthrie ([hidden email]) sent
> on Thursday, June 21, 2012 at 10:10 AM (-0400):
>
>> The FileMaker ODBC drivers are distributed with the FMSA package from
>> what I recall.
>> Are you using FMS or FMSA? Someone correct me if I am wrong but I'm
>> pretty sure ODBC only comes with Advanced.
>>
>> On 2012-06-21, at 9:49 AM, Patrick Larkin wrote:
>>
>>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?  
>>>
>>> I have Filemaker clients accessing MySQL over ODBC by installing
>> MySQL's provided ODBC driver on the Filemaker Server and then setting up
>> the Filemaker database accordingly.  
>>>
>>> This, however, is the opposite.  I want Filemaker to do be the data
>> source but I don't see any ODBC driver from Filemaker to run on the
>> server so Lasso will see it.  I'm assuming I have to install a driver on
>> the Filemaker Server (other than the MySQL driver used for a solely
>> different purpose) and set it up as a DSN using Apple's ODBC
>> Administrator.  THen I need to tell Lasso about it.
>>>
>>> But where is this elusive driver?
>>>
>>>
>>> Patrick
>>>
>>> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>>
>>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso
>> Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-
>> Publishing-dead-slow-tp4016733p4017063.html
>>>>
>>>> As far as the IIS timeout, you can change that setting.
>>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-
>> tp3131750p3131751.html
>>>>
>>>> There's also a hack.
>>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>>
>>>>> Not confirmed to work with 8.6 afaik.
>>>>>
>>>>>
>>>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>>
>>>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>>> FMS11 on today's hardware.
>>>>>>>
>>>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>>
>>>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>>> dev server performed better than the Windows server used in
>>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>>> better with that setup.
>>>>>>>
>>>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>>> The strange part is that It is roughly 3 times faster on a three
> server
>>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker
> Server 6)
>>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>>
>>>>>>>> The new setup is web server _ Filemaker 10 Server Advanced
> running on a
>>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted
> without
>>>>>> modification to the Filemaker 11 platform.  I expected a marked
>> improvement
>>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>>
>>>>>>>> Patrick Larkin
>>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>>> Bethlehem Area School District
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>>
>>>>>>>>> one way to get a look at what's happening throughout your page
>> is using
>>>>>> some simple timers, however, it sounds like your issues are likely
>> with the
>>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>>
>>>>>>>>> simple timer:
>>>>>>>>> get the page start time in milliseconds
>>>>>>>>>     local('start' = date_msec);
>>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>>     (date_msec - #start)+'ms';
>>>>>>>>>
>>>>>>>>> by comparing the time elapsed from one code block to the next,
> you can
>>>>>> see how long each piece is taking and compare results if you experiment
>>>>>> with different layouts or methods of organizing your data and
>> processing it.
>>>>>>>>>
>>>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>>> significantly from nested inlines, so you may want to wrap both
>> inlines in
>>>>>> an outer inline or just simply nest the second inline inside the
>> first (not
>>>>>> inside the records container ;)  ) and test to see if you get
> performance
>>>>>> gains from there.
>>>>>>>>>
>>>>>>>>> In addition, you may wish to double check the Filemaker server
>> setup to
>>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>>> necessarily good for web interaction.
>>>>>>>>>
>>>>>>>>> Tim Taplin
>>>>>>>>>
>>>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>>
>>>>>>>>>> Hello -
>>>>>>>>>>
>>>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.
> The page
>>>>>> I'm working on loads significantly faster with Filemaker 6(!) and
>> am trying
>>>>>> to track down what the issue might be.
>>>>>>>>>>
>>>>>>>>>> The page simply runs one inline to pull student demographics and
>>>>>> another inline from another database to pull a dozen other fields.  The
>>>>>> inlines put everything into variables which are then displayed in
>> the page
>>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>>
>>>>>>>>>> What are some techniques people use?  I tried moving the [abort] tag
>>>>>> around but that only gets me so far.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Patrick
>>>>>>>>>> #############################################################
>>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>>> the mailing list Lasso
>>>>>>>>>> [hidden email]
>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <--
>>>>>>> Mvh
>>>>>>> Johan Sölve
>>>>>>> ____________________________________
>>>>>>> Montania System AB
>>>>>>> Halmstad   Stockholm
>>>>>>> http://www.montania.se
>>>>>>>
>>>>>>> Johan Sölve
>>>>>>> Mobil +46 709-51 55 70
>>>>>>> [hidden email]
>>>>>>>
>>>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>
>>>>>
>>>>>
>>>>
>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> Jono
>>
>> ----------------------------
>> Jonathan Guthrie
>> [hidden email]
>> LassoSoft Inc.
>> +1 888-286-7753 ext 708
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

stevepiercy
In reply to this post by Patrick Larkin-2
On 6/21/12 at 9:49 AM, [hidden email] (Patrick Larkin) pronounced:

> Has anyone actually done ODBC and Lasso on Filemaker Server 10?

No, it's not possible with FMS 10.

According to the docs, it should work with FMSA 10.  Lasso would be a client to FMSA 10.
http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf

--steve


> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's provided
> ODBC driver on the Filemaker Server and then setting up the Filemaker database
> accordingly.  
>
> This, however, is the opposite.  I want Filemaker to do be the data source but I
> don't see any ODBC driver from Filemaker to run on the server so Lasso will see
> it.  I'm assuming I have to install a driver on the Filemaker Server (other than
> the MySQL driver used for a solely different purpose) and set it up as a DSN using
> Apple's ODBC Administrator.  THen I need to tell Lasso about it.
>
> But where is this elusive driver?
>
>
> Patrick
>
> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>
> > Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector
> for FMS9 or FMSA on 8.6, but not any reproducible test results.
> >
> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-
> slow-tp4016733p4017063.html
> >
> > As far as the IIS timeout, you can change that setting.
> > http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
> >
> > There's also a hack.
> > http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
> >
> > --steve
> >
> >
> > On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
> >
> >> Not confirmed to work with 8.6 afaik.
> >>
> >>
> >> 2012/6/21 Ke Carlton <[hidden email]>:
> >>> Based on reports, using odbc with FMSA is much faster.
> >>>
> >>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
> >>>> This is somewhat the same results I got when migrating an ancient FM6
> >>>> based site to FMS11 (intermediate migration in wait for a complete
> >>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
> >>>> FMS11 on today's hardware.
> >>>>
> >>>> I had to do some serious cache juggling with cache priming and all to
> >>>> get decent performance. Layout optimizations didn't help much. It
> >>>> seems the Lasso FM SA connector burns a lot of time parsing and
> >>>> preparing the XML result since the raw response is, ehum, less slow.
> >>>>
> >>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
> >>>> dev server performed better than the Windows server used in
> >>>> production. We are experimenting with using FMS11 with Apache on
> >>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
> >>>> kills nightly maintenance routines. This setup is not supported by FMI
> >>>> but seems to work fine. Next step is to find out if performance is any
> >>>> better with that setup.
> >>>>
> >>>> 2012/6/20 Patrick Larkin <[hidden email]>:
> >>>>> The strange part is that It is roughly 3 times faster on a three server
> >>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
> >>> with the Filemaker portion running on archaic G4 towers running 10.2.
> >>>>>
> >>>>> The new setup is web server _ Filemaker 10 Server Advanced running on a
> >>> quad-core Xeon Xserve running 10.5.  The databases were converted without
> >>> modification to the Filemaker 11 platform.  I expected a marked improvement
> >>> just on horsepower and OS improvements alone!  :)
> >>>>>
> >>>>> Patrick Larkin
> >>>>> Developer/Administrator of Special Systems / Webmaster
> >>>>> Bethlehem Area School District
> >>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
> >>>>>
> >>>>>> one way to get a look at what's happening throughout your page is using
> >>> some simple timers, however, it sounds like your issues are likely with the
> >>> Filemaker interaction and not within your lasso code.
> >>>>>>
> >>>>>> simple timer:
> >>>>>> get the page start time in milliseconds
> >>>>>>       local('start' = date_msec);
> >>>>>> Anywhere you need to know the elapsed time, output this:
> >>>>>>       (date_msec - #start)+'ms';
> >>>>>>
> >>>>>> by comparing the time elapsed from one code block to the next, you can
> >>> see how long each piece is taking and compare results if you experiment
> >>> with different layouts or methods of organizing your data and processing it.
> >>>>>>
> >>>>>> It sounds like you may be in for some Filemaker hacking though.
> >>> reviewing each layout to make sure you have layouts that use properly
> >>> indexed fields, dont have extra fields on the layout that you are not
> >>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
> >>> significantly from nested inlines, so you may want to wrap both inlines in
> >>> an outer inline or just simply nest the second inline inside the first (not
> >>> inside the records container ;)  ) and test to see if you get performance
> >>> gains from there.
> >>>>>>
> >>>>>> In addition, you may wish to double check the Filemaker server setup to
> >>> make sure you have allowed enough resources, as the defaults are not
> >>> necessarily good for web interaction.
> >>>>>>
> >>>>>> Tim Taplin
> >>>>>>
> >>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
> >>>>>>
> >>>>>>> Hello -
> >>>>>>>
> >>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
> >>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
> >>> to track down what the issue might be.
> >>>>>>>
> >>>>>>> The page simply runs one inline to pull student demographics and
> >>> another inline from another database to pull a dozen other fields.  The
> >>> inlines put everything into variables which are then displayed in the page
> >>> using [var:'theVar'] tags.  Nothing at all unusual.
> >>>>>>>
> >>>>>>> What are some techniques people use?  I tried moving the [abort] tag
> >>> around but that only gets me so far.
> >>>>>>>
> >>>>>>>
> >>>>>>> Patrick
> >>>>>>> #############################################################
> >>>>>>> This message is sent to you because you are subscribed to
> >>>>>>> the mailing list Lasso
> >>>>>>> [hidden email]
> >>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>
> >>>>>> #############################################################
> >>>>>> This message is sent to you because you are subscribed to
> >>>>>>  the mailing list Lasso
> >>>>>> [hidden email]
> >>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>
> >>>>>
> >>>>> #############################################################
> >>>>> This message is sent to you because you are subscribed to
> >>>>>  the mailing list Lasso
> >>>>> [hidden email]
> >>>>> To unsubscribe, E-mail to: <--
> >>>> Mvh
> >>>> Johan Sölve
> >>>> ____________________________________
> >>>> Montania System AB
> >>>> Halmstad   Stockholm
> >>>> http://www.montania.se
> >>>>
> >>>> Johan Sölve
> >>>> Mobil +46 709-51 55 70
> >>>> [hidden email]
> >>>>
> >>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> >>>> Telefon +46 35-136800 |  Fax +46 35-136801
> >>>> #############################################################
> >>>> This message is sent to you because you are subscribed to
> >>>>  the mailing list Lasso
> >>>> [hidden email]
> >>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>> Send administrative queries to  <[hidden email]>
> >>>>
> >>> #############################################################
> >>> This message is sent to you because you are subscribed to
> >>>  the mailing list Lasso
> >>> [hidden email]
> >>> To unsubscribe, E-mail to: <[hidden email]>
> >>> Send administrative queries to  <[hidden email]>
> >>
> >>
> >>
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > Steve Piercy               Web Site Builder               Soquel, CA
> > <[hidden email]>                  <http://www.StevePiercy.com/>
> >
> > #############################################################
> > This message is sent to you because you are subscribed to
> > the mailing list Lasso
> > [hidden email]
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy               Web Site Builder               Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Carl Ketterling
In reply to this post by Patrick Larkin-2
In FMSA v11, I open the database, choose File > Manage > Security.  I
choose Privilege Sets and edit a privilege set.  In a section named
"Extended Privileges", I have "Access via ODBC/JDBC (fmxdbc)" as a
checkbox item that I could use.

Unfortunately, I went from FM v6 to v11, so I have no idea what v10
looks like.  I do know that I had a terrible time finding this screen
when I started this.

Carl


In response to this text from Patrick Larkin ([hidden email])
sent on Thursday, June 21, 2012 at 10:15 AM (-0400):

>I am using Filemaker Server Advanced version 10.
>
>But I have a license for version 11 if that's what I need.  I don't see
>anything obviously labeled as an ODBC driver.
>
>
>Patrick Larkin
>Developer/Administrator of Special Systems / Webmaster
>Bethlehem Area School District
>
>
>
>
>On Jun 21, 2012, at 10:10 AM, Jonathan Guthrie wrote:
>
>> The FileMaker ODBC drivers are distributed with the FMSA package from
>what I recall.
>> Are you using FMS or FMSA? Someone correct me if I am wrong but I'm
>pretty sure ODBC only comes with Advanced.
>>
>> On 2012-06-21, at 9:49 AM, Patrick Larkin wrote:
>>
>>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?  
>>>
>>> I have Filemaker clients accessing MySQL over ODBC by installing
>MySQL's provided ODBC driver on the Filemaker Server and then setting up
>the Filemaker database accordingly.  
>>>
>>> This, however, is the opposite.  I want Filemaker to do be the data
>source but I don't see any ODBC driver from Filemaker to run on the
>server so Lasso will see it.  I'm assuming I have to install a driver on
>the Filemaker Server (other than the MySQL driver used for a solely
>different purpose) and set it up as a DSN using Apple's ODBC
>Administrator.  THen I need to tell Lasso about it.
>>>
>>> But where is this elusive driver?
>>>
>>>
>>> Patrick
>>>
>>> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>>
>>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso
>Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-
>Publishing-dead-slow-tp4016733p4017063.html
>>>>
>>>> As far as the IIS timeout, you can change that setting.
>>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-
>tp3131750p3131751.html
>>>>
>>>> There's also a hack.
>>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>>
>>>> --steve
>>>>
>>>>
>>>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>>
>>>>> Not confirmed to work with 8.6 afaik.
>>>>>
>>>>>
>>>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>>
>>>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>>> FMS11 on today's hardware.
>>>>>>>
>>>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>>
>>>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>>> dev server performed better than the Windows server used in
>>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>>> better with that setup.
>>>>>>>
>>>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>>> The strange part is that It is roughly 3 times faster on a three
>server
>>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker
>Server 6)
>>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>>
>>>>>>>> The new setup is web server _ Filemaker 10 Server Advanced
>running on a
>>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted
>without
>>>>>> modification to the Filemaker 11 platform.  I expected a marked
>improvement
>>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>>
>>>>>>>> Patrick Larkin
>>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>>> Bethlehem Area School District
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>>
>>>>>>>>> one way to get a look at what's happening throughout your page
>is using
>>>>>> some simple timers, however, it sounds like your issues are likely
>with the
>>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>>
>>>>>>>>> simple timer:
>>>>>>>>> get the page start time in milliseconds
>>>>>>>>>     local('start' = date_msec);
>>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>>     (date_msec - #start)+'ms';
>>>>>>>>>
>>>>>>>>> by comparing the time elapsed from one code block to the next,
>you can
>>>>>> see how long each piece is taking and compare results if you experiment
>>>>>> with different layouts or methods of organizing your data and
>processing it.
>>>>>>>>>
>>>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>>> significantly from nested inlines, so you may want to wrap both
>inlines in
>>>>>> an outer inline or just simply nest the second inline inside the
>first (not
>>>>>> inside the records container ;)  ) and test to see if you get
>performance
>>>>>> gains from there.
>>>>>>>>>
>>>>>>>>> In addition, you may wish to double check the Filemaker server
>setup to
>>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>>> necessarily good for web interaction.
>>>>>>>>>
>>>>>>>>> Tim Taplin
>>>>>>>>>
>>>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>>
>>>>>>>>>> Hello -
>>>>>>>>>>
>>>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.
>The page
>>>>>> I'm working on loads significantly faster with Filemaker 6(!) and
>am trying
>>>>>> to track down what the issue might be.
>>>>>>>>>>
>>>>>>>>>> The page simply runs one inline to pull student demographics and
>>>>>> another inline from another database to pull a dozen other fields.  The
>>>>>> inlines put everything into variables which are then displayed in
>the page
>>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>>
>>>>>>>>>> What are some techniques people use?  I tried moving the
[abort] tag

>>>>>> around but that only gets me so far.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Patrick
>>>>>>>>>> #############################################################
>>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>>> the mailing list Lasso
>>>>>>>>>> [hidden email]
>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <--
>>>>>>> Mvh
>>>>>>> Johan Sölve
>>>>>>> ____________________________________
>>>>>>> Montania System AB
>>>>>>> Halmstad   Stockholm
>>>>>>> http://www.montania.se
>>>>>>>
>>>>>>> Johan Sölve
>>>>>>> Mobil +46 709-51 55 70
>>>>>>> [hidden email]
>>>>>>>
>>>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>
>>>>>
>>>>>
>>>>
>>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>
>>>> #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> Jono
>>
>> ----------------------------
>> Jonathan Guthrie
>> [hidden email]
>> LassoSoft Inc.
>> +1 888-286-7753 ext 708
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>>
>
>#############################################################
>This message is sent to you because you are subscribed to
>  the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Patrick Larkin-2
In reply to this post by stevepiercy
I saw that document.  It references Filemaker 10 the client but no Server Advanced.  All it says it copy the SequelLink.buncdle file into the ODBC directory.  No instructions on setting up the driver in ODBC Administrator.  And I can find no directions for configuring a FMSA machine to accept ODBC queries from a 3rd party client anywhere.  

I think I'm abandoning this black hole.  This is extremely frustrating.  I guess FMP10 is not a viable option to use with Lasso if it is this much slower than Filemaker 5/6.

Patrick



On Jun 21, 2012, at 10:22 AM, Steve Piercy - Web Site Builder wrote:

> On 6/21/12 at 9:49 AM, [hidden email] (Patrick Larkin) pronounced:
>
>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?
>
> No, it's not possible with FMS 10.
>
> According to the docs, it should work with FMSA 10.  Lasso would be a client to FMSA 10.
> http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
>
> --steve
>
>
>> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's provided
>> ODBC driver on the Filemaker Server and then setting up the Filemaker database
>> accordingly.  
>>
>> This, however, is the opposite.  I want Filemaker to do be the data source but I
>> don't see any ODBC driver from Filemaker to run on the server so Lasso will see
>> it.  I'm assuming I have to install a driver on the Filemaker Server (other than
>> the MySQL driver used for a solely different purpose) and set it up as a DSN using
>> Apple's ODBC Administrator.  THen I need to tell Lasso about it.
>>
>> But where is this elusive driver?
>>
>>
>> Patrick
>>
>> On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>
>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector
>> for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>>
>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-
>> slow-tp4016733p4017063.html
>>>
>>> As far as the IIS timeout, you can change that setting.
>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
>>>
>>> There's also a hack.
>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>
>>> --steve
>>>
>>>
>>> On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>
>>>> Not confirmed to work with 8.6 afaik.
>>>>
>>>>
>>>> 2012/6/21 Ke Carlton <[hidden email]>:
>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>
>>>>> On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>> FMS11 on today's hardware.
>>>>>>
>>>>>> I had to do some serious cache juggling with cache priming and all to
>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>
>>>>>> I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>> dev server performed better than the Windows server used in
>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>> better with that setup.
>>>>>>
>>>>>> 2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>> The strange part is that It is roughly 3 times faster on a three server
>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>
>>>>>>> The new setup is web server _ Filemaker 10 Server Advanced running on a
>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
>>>>> modification to the Filemaker 11 platform.  I expected a marked improvement
>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>
>>>>>>> Patrick Larkin
>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>> Bethlehem Area School District
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>
>>>>>>>> one way to get a look at what's happening throughout your page is using
>>>>> some simple timers, however, it sounds like your issues are likely with the
>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>
>>>>>>>> simple timer:
>>>>>>>> get the page start time in milliseconds
>>>>>>>>      local('start' = date_msec);
>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>      (date_msec - #start)+'ms';
>>>>>>>>
>>>>>>>> by comparing the time elapsed from one code block to the next, you can
>>>>> see how long each piece is taking and compare results if you experiment
>>>>> with different layouts or methods of organizing your data and processing it.
>>>>>>>>
>>>>>>>> It sounds like you may be in for some Filemaker hacking though.
>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>> significantly from nested inlines, so you may want to wrap both inlines in
>>>>> an outer inline or just simply nest the second inline inside the first (not
>>>>> inside the records container ;)  ) and test to see if you get performance
>>>>> gains from there.
>>>>>>>>
>>>>>>>> In addition, you may wish to double check the Filemaker server setup to
>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>> necessarily good for web interaction.
>>>>>>>>
>>>>>>>> Tim Taplin
>>>>>>>>
>>>>>>>> On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>
>>>>>>>>> Hello -
>>>>>>>>>
>>>>>>>>> I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
>>>>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
>>>>> to track down what the issue might be.
>>>>>>>>>
>>>>>>>>> The page simply runs one inline to pull student demographics and
>>>>> another inline from another database to pull a dozen other fields.  The
>>>>> inlines put everything into variables which are then displayed in the page
>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>
>>>>>>>>> What are some techniques people use?  I tried moving the [abort] tag
>>>>> around but that only gets me so far.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Patrick
>>>>>>>>> #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <--
>>>>>> Mvh
>>>>>> Johan Sölve
>>>>>> ____________________________________
>>>>>> Montania System AB
>>>>>> Halmstad   Stockholm
>>>>>> http://www.montania.se
>>>>>>
>>>>>> Johan Sölve
>>>>>> Mobil +46 709-51 55 70
>>>>>> [hidden email]
>>>>>>
>>>>>> Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>
>>>>> #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>
>>>>
>>>>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>>  the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Patrick Larkin-2
In reply to this post by Carl Ketterling
Sure.  That turns on the ability for the data to be shared.  But you also need a driver on the server that Lasso can connect to, AFAIK.

And Filemaker 10 and 11 are pretty much identical with some UI changes.  

Patrick



On Jun 21, 2012, at 10:35 AM, Carl Ketterling wrote:

> In FMSA v11, I open the database, choose File > Manage > Security.  I
> choose Privilege Sets and edit a privilege set.  In a section named
> "Extended Privileges", I have "Access via ODBC/JDBC (fmxdbc)" as a
> checkbox item that I could use.
>
> Unfortunately, I went from FM v6 to v11, so I have no idea what v10
> looks like.  I do know that I had a terrible time finding this screen
> when I started this.
>
> Carl

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Ke Carlton-3
Really, are you sure it's not the other way round? ie. The client driver on
the machine connecting to the ODBC datasource...

Simply setup a ODBC DSN using an appropriate client driver and ODBC
administrator on the machine hosting Lasso, point it to your FMSA server
and test using The ODBC administrator. The client driver goes on the
machine that needs to connect to the server and speaks what ever language
needs to be spoken to the server and relays that to the client as ODBC. So
effectively you just need to enable ODBC on the server and configure the
driver on the client.

When toying around with this I came across plenty of guides when googling
FMSA ODBC etc... and got it up and running, but for that particular
solution we found it more appropriate to install a mysql ODBC client driver
on the FMSA server and have Filemaker connect to MySql instead.

Ke

On Thursday, 21 June 2012, Patrick Larkin <[hidden email]> wrote:
> Sure.  That turns on the ability for the data to be shared.  But you also
need a driver on the server that Lasso can connect to, AFAIK.

>
> And Filemaker 10 and 11 are pretty much identical with some UI changes.
>
> Patrick
>
>
>
> On Jun 21, 2012, at 10:35 AM, Carl Ketterling wrote:
>
>> In FMSA v11, I open the database, choose File > Manage > Security.  I
>> choose Privilege Sets and edit a privilege set.  In a section named
>> "Extended Privileges", I have "Access via ODBC/JDBC (fmxdbc)" as a
>> checkbox item that I could use.
>>
>> Unfortunately, I went from FM v6 to v11, so I have no idea what v10
>> looks like.  I do know that I had a terrible time finding this screen
>> when I started this.
>>
>> Carl
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
>
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Carl Ketterling
In reply to this post by Patrick Larkin-2
According to FileMaker Training document...

(using FileMaker Server Advanced)
 - open FileMaker Server Admin Console
 - select ODBC/JDBC
 - click Enable ODBC/JDBC

That's it.

NOTE: (per same document) ODBC is usable by a local program for
FileMaker Pro and FileMaker Server, while network access requires
FileMaker Server Advanced.


In response to this text from Patrick Larkin ([hidden email])
sent on Thursday, June 21, 2012 at 10:37 AM (-0400):

>Sure.  That turns on the ability for the data to be shared.  But you
>also need a driver on the server that Lasso can connect to, AFAIK.
>
>And Filemaker 10 and 11 are pretty much identical with some UI changes.  
>
>Patrick
>
>
>
>On Jun 21, 2012, at 10:35 AM, Carl Ketterling wrote:
>
>> In FMSA v11, I open the database, choose File > Manage > Security.  I
>> choose Privilege Sets and edit a privilege set.  In a section named
>> "Extended Privileges", I have "Access via ODBC/JDBC (fmxdbc)" as a
>> checkbox item that I could use.
>>
>> Unfortunately, I went from FM v6 to v11, so I have no idea what v10
>> looks like.  I do know that I had a terrible time finding this screen
>> when I started this.
>>
>> Carl
>
>#############################################################
>This message is sent to you because you are subscribed to
>  the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

stevepiercy
In reply to this post by Patrick Larkin-2
You need to be more thorough with your reading of the document,
and not just skim it.  Filemaker documentation is verbose
narrative, which tends to put off the frustrated and impatient reader.
http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf

See "Specifying ODBC client driver properties for a FileMaker
DSN (Mac OS)" on pp. 19-20.

FYI, ODBC Administrator for Mac OS X is located at:
/Applications/Utilities/ODBC Administrator

--steve



On 6/21/12 at 10:36 AM, [hidden email] (Patrick Larkin) pronounced:

>I saw that document.  It references Filemaker 10 the client but
>no Server Advanced.  All it says it copy the SequelLink.buncdle
>file into the ODBC directory.  No instructions on setting up
>the driver in ODBC Administrator.  And I can find no directions
>for configuring a FMSA machine to accept ODBC queries from a
>3rd party client anywhere.
>I think I'm abandoning this black hole.  This is extremely
>frustrating.  I guess FMP10 is not a viable option to use with
>Lasso if it is this much slower than Filemaker 5/6.
>
>Patrick
>
>
>On Jun 21, 2012, at 10:22 AM, Steve Piercy - Web Site Builder wrote:
>
>>On 6/21/12 at 9:49 AM, [hidden email] (Patrick Larkin) pronounced:
>>
>>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?
>>
>>No, it's not possible with FMS 10.
>>
>>According to the docs, it should work with FMSA 10.  Lasso would be a client to
>FMSA 10.
>>http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
>>
>>--steve
>>
>>
>>> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's
>provided
>>>  ODBC driver on the Filemaker Server and then setting up the
>>>Filemaker database  accordingly.    This, however, is the
>>>opposite.  I want Filemaker to do be the data source but
>I
>>>  don't see any ODBC driver from Filemaker to run on the
>>>server so Lasso will see  it.  I'm assuming I have to install
>>>a driver on the Filemaker Server (other
>than
>>> the MySQL driver used for a solely different purpose) and set it up as a DSN
>using
>>>  Apple's ODBC Administrator.  THen I need to tell Lasso
>>>about it.   But where is this elusive driver?
>>>    Patrick   On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web
>>>Site Builder wrote:
>>>
>>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector
>>> for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>>>
>>>
>http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-
>>> slow-tp4016733p4017063.html
>>>>   As far as the IIS timeout, you can change that setting.
>>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
>>>>   There's also a hack.
>>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>>   --steve
>>>>    On 6/21/12 at 11:19 AM, [hidden email] (Johan
>>>>Solve) pronounced:
>>>>
>>>>> Not confirmed to work with 8.6 afaik.
>>>>>    2012/6/21 Ke Carlton <[hidden email]>:
>>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>>   On Thursday, 21 June 2012, Johan Solve
>>>>>><[hidden email]> wrote:
>>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>>> FMS11 on today's hardware.
>>>>>>>   I had to do some serious cache juggling with cache
>>>>>>>priming and all to
>>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>>   I suspect FMS11 on Windows/IIS is one factor since the
>>>>>>>fairly old Mac
>>>>>>> dev server performed better than the Windows server used in
>>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>>> better with that setup.
>>>>>>>   2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>>> The strange part is that It is roughly 3 times faster on a three server
>>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
>>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>>   The new setup is web server _ Filemaker 10 Server
>>>>>>>>Advanced running on a
>>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
>>>>>> modification to the Filemaker 11 platform.  I expected a marked improvement
>>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>>   Patrick Larkin
>>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>>> Bethlehem Area School District
>>>>>>>>      On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>>
>>>>>>>>> one way to get a look at what's happening throughout your page is using
>>>>>> some simple timers, however, it sounds like your issues are likely with the
>>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>>   simple timer:
>>>>>>>>> get the page start time in milliseconds
>>>>>>>>>      local('start' = date_msec);
>>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>>      (date_msec - #start)+'ms';
>>>>>>>>>   by comparing the time elapsed from one code block to
>>>>>>>>>the next, you can
>>>>>> see how long each piece is taking and compare results if you experiment
>>>>>> with different layouts or methods of organizing your data and processing it.
>>>>>>>>>   It sounds like you may be in for some Filemaker
>>>>>>>>>hacking though.
>>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>>> significantly from nested inlines, so you may want to wrap both inlines in
>>>>>> an outer inline or just simply nest the second inline inside the first (not
>>>>>> inside the records container ;)  ) and test to see if you get performance
>>>>>> gains from there.
>>>>>>>>>   In addition, you may wish to double check the
>>>>>>>>>Filemaker server setup to
>>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>>> necessarily good for web interaction.
>>>>>>>>>   Tim Taplin
>>>>>>>>>   On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>>
>>>>>>>>>> Hello -
>>>>>>>>>>   I'm trying out some things with Lasso 8.6 and
>>>>>>>>>>Filemaker 11.  The page
>>>>>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
>>>>>> to track down what the issue might be.
>>>>>>>>>>   The page simply runs one inline to pull student
>>>>>>>>>>demographics and
>>>>>> another inline from another database to pull a dozen other fields.  The
>>>>>> inlines put everything into variables which are then displayed in the page
>>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>>   What are some techniques people use?  I tried
>>>>>>>>>>moving the [abort] tag
>>>>>> around but that only gets me so far.
>>>>>>>>>>    Patrick
>>>>>>>>>> #############################################################
>>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>>> the mailing list Lasso
>>>>>>>>>> [hidden email]
>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>   #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>
>>>>>>>>   #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <--
>>>>>>> Mvh
>>>>>>> Johan Sölve
>>>>>>> ____________________________________
>>>>>>> Montania System AB
>>>>>>> Halmstad   Stockholm
>>>>>>> http://www.montania.se
>>>>>>>   Johan Sölve
>>>>>>> Mobil +46 709-51 55 70
>>>>>>> [hidden email]
>>>>>>>   Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>
>>>>>> #############################################################
>>>>>> This message is sent to you because you are subscribed to
>>>>>> the mailing list Lasso
>>>>>> [hidden email]
>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>> Send administrative queries to  <[hidden email]>
>>>>>  
>>>>   -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>-- -- -- --
>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>   #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>   #############################################################
>>> This message is sent to you because you are subscribed to
>>>  the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>>-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>Steve Piercy               Web Site Builder               Soquel, CA
>><[hidden email]>                  <http://www.StevePiercy.com/>
>>
>>#############################################################
>>This message is sent to you because you are subscribed to
>>the mailing list Lasso
>>[hidden email]
>>To unsubscribe, E-mail to: <[hidden email]>
>>Send administrative queries to  <[hidden email]>
>
>#############################################################
>This message is sent to you because you are subscribed to
>the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- --
Steve Piercy               Web Site Builder              
Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Patrick Larkin-2
Thanks.  I'll check it out.  

It would help if the document wasn't titled without a reference to server.  And the confusing assertion that serving databases via ODBC is exclusive to their advanced product and not have documents specifically for that product.

I also have the server working for years with the MySQL ODBC driver in ODBC administrator.


On Jun 21, 2012, at 5:55 PM, Steve Piercy - Web Site Builder <[hidden email]> wrote:

> You need to be more thorough with your reading of the document, and not just skim it.  Filemaker documentation is verbose narrative, which tends to put off the frustrated and impatient reader.
> http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
>
> See "Specifying ODBC client driver properties for a FileMaker DSN (Mac OS)" on pp. 19-20.
>
> FYI, ODBC Administrator for Mac OS X is located at:
> /Applications/Utilities/ODBC Administrator
>
> --steve
>
>
>
> On 6/21/12 at 10:36 AM, [hidden email] (Patrick Larkin) pronounced:
>
>> I saw that document.  It references Filemaker 10 the client but no Server Advanced.  All it says it copy the SequelLink.buncdle file into the ODBC directory.  No instructions on setting up the driver in ODBC Administrator.  And I can find no directions for configuring a FMSA machine to accept ODBC queries from a 3rd party client anywhere.
>> I think I'm abandoning this black hole.  This is extremely frustrating.  I guess FMP10 is not a viable option to use with Lasso if it is this much slower than Filemaker 5/6.
>>
>> Patrick
>>
>>
>> On Jun 21, 2012, at 10:22 AM, Steve Piercy - Web Site Builder wrote:
>>
>>> On 6/21/12 at 9:49 AM, [hidden email] (Patrick Larkin) pronounced:
>>>
>>>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?
>>>
>>> No, it's not possible with FMS 10.
>>>
>>> According to the docs, it should work with FMSA 10.  Lasso would be a client to
>> FMSA 10.
>>> http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
>>>
>>> --steve
>>>
>>>
>>>> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's
>> provided
>>>> ODBC driver on the Filemaker Server and then setting up the Filemaker database  accordingly.    This, however, is the opposite.  I want Filemaker to do be the data source but
>> I
>>>> don't see any ODBC driver from Filemaker to run on the server so Lasso will see  it.  I'm assuming I have to install a driver on the Filemaker Server (other
>> than
>>>> the MySQL driver used for a solely different purpose) and set it up as a DSN
>> using
>>>> Apple's ODBC Administrator.  THen I need to tell Lasso about it.   But where is this elusive driver?
>>>>   Patrick   On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder wrote:
>>>>
>>>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso Connector
>>>> for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>>>>
>>>>
>> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-
>>>> slow-tp4016733p4017063.html
>>>>>  As far as the IIS timeout, you can change that setting.
>>>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
>>>>>  There's also a hack.
>>>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
>>>>>  --steve
>>>>>   On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
>>>>>
>>>>>> Not confirmed to work with 8.6 afaik.
>>>>>>   2012/6/21 Ke Carlton <[hidden email]>:
>>>>>>> Based on reports, using odbc with FMSA is much faster.
>>>>>>>  On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
>>>>>>>> This is somewhat the same results I got when migrating an ancient FM6
>>>>>>>> based site to FMS11 (intermediate migration in wait for a complete
>>>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
>>>>>>>> FMS11 on today's hardware.
>>>>>>>>  I had to do some serious cache juggling with cache priming and all to
>>>>>>>> get decent performance. Layout optimizations didn't help much. It
>>>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
>>>>>>>> preparing the XML result since the raw response is, ehum, less slow.
>>>>>>>>  I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
>>>>>>>> dev server performed better than the Windows server used in
>>>>>>>> production. We are experimenting with using FMS11 with Apache on
>>>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
>>>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
>>>>>>>> but seems to work fine. Next step is to find out if performance is any
>>>>>>>> better with that setup.
>>>>>>>>  2012/6/20 Patrick Larkin <[hidden email]>:
>>>>>>>>> The strange part is that It is roughly 3 times faster on a three server
>>>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
>>>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
>>>>>>>>>  The new setup is web server _ Filemaker 10 Server Advanced running on a
>>>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
>>>>>>> modification to the Filemaker 11 platform.  I expected a marked improvement
>>>>>>> just on horsepower and OS improvements alone!  :)
>>>>>>>>>  Patrick Larkin
>>>>>>>>> Developer/Administrator of Special Systems / Webmaster
>>>>>>>>> Bethlehem Area School District
>>>>>>>>>     On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
>>>>>>>>>
>>>>>>>>>> one way to get a look at what's happening throughout your page is using
>>>>>>> some simple timers, however, it sounds like your issues are likely with the
>>>>>>> Filemaker interaction and not within your lasso code.
>>>>>>>>>>  simple timer:
>>>>>>>>>> get the page start time in milliseconds
>>>>>>>>>>     local('start' = date_msec);
>>>>>>>>>> Anywhere you need to know the elapsed time, output this:
>>>>>>>>>>     (date_msec - #start)+'ms';
>>>>>>>>>>  by comparing the time elapsed from one code block to the next, you can
>>>>>>> see how long each piece is taking and compare results if you experiment
>>>>>>> with different layouts or methods of organizing your data and processing it.
>>>>>>>>>>  It sounds like you may be in for some Filemaker hacking though.
>>>>>>> reviewing each layout to make sure you have layouts that use properly
>>>>>>> indexed fields, dont have extra fields on the layout that you are not
>>>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
>>>>>>> significantly from nested inlines, so you may want to wrap both inlines in
>>>>>>> an outer inline or just simply nest the second inline inside the first (not
>>>>>>> inside the records container ;)  ) and test to see if you get performance
>>>>>>> gains from there.
>>>>>>>>>>  In addition, you may wish to double check the Filemaker server setup to
>>>>>>> make sure you have allowed enough resources, as the defaults are not
>>>>>>> necessarily good for web interaction.
>>>>>>>>>>  Tim Taplin
>>>>>>>>>>  On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
>>>>>>>>>>
>>>>>>>>>>> Hello -
>>>>>>>>>>>  I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
>>>>>>> I'm working on loads significantly faster with Filemaker 6(!) and am trying
>>>>>>> to track down what the issue might be.
>>>>>>>>>>>  The page simply runs one inline to pull student demographics and
>>>>>>> another inline from another database to pull a dozen other fields.  The
>>>>>>> inlines put everything into variables which are then displayed in the page
>>>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
>>>>>>>>>>>  What are some techniques people use?  I tried moving the [abort] tag
>>>>>>> around but that only gets me so far.
>>>>>>>>>>>   Patrick
>>>>>>>>>>> #############################################################
>>>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>>>> the mailing list Lasso
>>>>>>>>>>> [hidden email]
>>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>>  #############################################################
>>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>>> the mailing list Lasso
>>>>>>>>>> [hidden email]
>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>>>
>>>>>>>>>  #############################################################
>>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>>> the mailing list Lasso
>>>>>>>>> [hidden email]
>>>>>>>>> To unsubscribe, E-mail to: <--
>>>>>>>> Mvh
>>>>>>>> Johan Sölve
>>>>>>>> ____________________________________
>>>>>>>> Montania System AB
>>>>>>>> Halmstad   Stockholm
>>>>>>>> http://www.montania.se
>>>>>>>>  Johan Sölve
>>>>>>>> Mobil +46 709-51 55 70
>>>>>>>> [hidden email]
>>>>>>>>  Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
>>>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
>>>>>>>> #############################################################
>>>>>>>> This message is sent to you because you are subscribed to
>>>>>>>> the mailing list Lasso
>>>>>>>> [hidden email]
>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>>>
>>>>>>> #############################################################
>>>>>>> This message is sent to you because you are subscribed to
>>>>>>> the mailing list Lasso
>>>>>>> [hidden email]
>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>>>> Send administrative queries to  <[hidden email]>
>>>>>>  
>>>>>  -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>>>> Steve Piercy               Web Site Builder               Soquel, CA
>>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>>>  #############################################################
>>>>> This message is sent to you because you are subscribed to
>>>>> the mailing list Lasso
>>>>> [hidden email]
>>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>>> Send administrative queries to  <[hidden email]>
>>>>  #############################################################
>>>> This message is sent to you because you are subscribed to
>>>> the mailing list Lasso
>>>> [hidden email]
>>>> To unsubscribe, E-mail to: <[hidden email]>
>>>> Send administrative queries to  <[hidden email]>
>>>
>>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
>>> Steve Piercy               Web Site Builder               Soquel, CA
>>> <[hidden email]>                  <http://www.StevePiercy.com/>
>>>
>>> #############################################################
>>> This message is sent to you because you are subscribed to
>>> the mailing list Lasso
>>> [hidden email]
>>> To unsubscribe, E-mail to: <[hidden email]>
>>> Send administrative queries to  <[hidden email]>
>>
>> #############################################################
>> This message is sent to you because you are subscribed to
>> the mailing list Lasso
>> [hidden email]
>> To unsubscribe, E-mail to: <[hidden email]>
>> Send administrative queries to  <[hidden email]>
>
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> Steve Piercy               Web Site Builder               Soquel, CA
> <[hidden email]>                  <http://www.StevePiercy.com/>
>
> #############################################################
> This message is sent to you because you are subscribed to
> the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

stevepiercy
Don't judge documentation by its cover.  ;)

--steve


On 6/21/12 at 7:01 PM, [hidden email] (Patrick Larkin) pronounced:

> Thanks.  I'll check it out.  
>
> It would help if the document wasn't titled without a reference to server.  And
> the confusing assertion that serving databases via ODBC is exclusive to their
> advanced product and not have documents specifically for that product.
>
> I also have the server working for years with the MySQL ODBC driver in ODBC
> administrator.
>
>
> On Jun 21, 2012, at 5:55 PM, Steve Piercy - Web Site Builder <[hidden email]>
> wrote:
>
> > You need to be more thorough with your reading of the document, and not just
> skim it.  Filemaker documentation is verbose narrative, which tends to put off the
> frustrated and impatient reader.
> > http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
> >
> > See "Specifying ODBC client driver properties for a FileMaker DSN (Mac OS)" on
> pp. 19-20.
> >
> > FYI, ODBC Administrator for Mac OS X is located at:
> > /Applications/Utilities/ODBC Administrator
> >
> > --steve
> >
> >
> >
> > On 6/21/12 at 10:36 AM, [hidden email] (Patrick Larkin) pronounced:
> >
> >> I saw that document.  It references Filemaker 10 the client but no Server
> Advanced.  All it says it copy the SequelLink.buncdle file into the ODBC
> directory.  No instructions on setting up the driver in ODBC Administrator.  And I
> can find no directions for configuring a FMSA machine to accept ODBC queries from
> a 3rd party client anywhere.
> >> I think I'm abandoning this black hole.  This is extremely frustrating.  I
> guess FMP10 is not a viable option to use with Lasso if it is this much slower
> than Filemaker 5/6.
> >>
> >> Patrick
> >>
> >>
> >> On Jun 21, 2012, at 10:22 AM, Steve Piercy - Web Site Builder wrote:
> >>
> >>> On 6/21/12 at 9:49 AM, [hidden email] (Patrick Larkin) pronounced:
> >>>
> >>>> Has anyone actually done ODBC and Lasso on Filemaker Server 10?
> >>>
> >>> No, it's not possible with FMS 10.
> >>>
> >>> According to the docs, it should work with FMSA 10.  Lasso would be a client
> to
> >> FMSA 10.
> >>> http://www.filemaker.com/downloads/pdf/fm10_odbc_jdbc_guide_en.pdf
> >>>
> >>> --steve
> >>>
> >>>
> >>>> I have Filemaker clients accessing MySQL over ODBC by installing MySQL's
> >> provided
> >>>> ODBC driver on the Filemaker Server and then setting up the Filemaker
> database  accordingly.    This, however, is the opposite.  I want Filemaker to do
> be the data source but
> >> I
> >>>> don't see any ODBC driver from Filemaker to run on the server so Lasso will
> see  it.  I'm assuming I have to install a driver on the Filemaker Server (other
> >> than
> >>>> the MySQL driver used for a solely different purpose) and set it up as a DSN
> >> using
> >>>> Apple's ODBC Administrator.  THen I need to tell Lasso about it.   But where
> is this elusive driver?
> >>>>   Patrick   On Jun 21, 2012, at 5:32 AM, Steve Piercy - Web Site Builder
> wrote:
> >>>>
> >>>>> Jono provided an anecdotal claim that ODBC is faster than the Lasso
> Connector
> >>>> for FMS9 or FMSA on 8.6, but not any reproducible test results.
> >>>>>
> >>>>
> >>
> http://lasso.2283332.n4.nabble.com/FileMaker-11-0-99-Custom-Web-Publishing-dead-
> >>>> slow-tp4016733p4017063.html
> >>>>>  As far as the IIS timeout, you can change that setting.
> >>>>> http://lasso.2283332.n4.nabble.com/Max-Execution-Time-tp3131750p3131751.html
> >>>>>  There's also a hack.
> >>>>> http://lasso.2283332.n4.nabble.com/IIS-Time-out-tp3148506p3148509.html
> >>>>>  --steve
> >>>>>   On 6/21/12 at 11:19 AM, [hidden email] (Johan Solve) pronounced:
> >>>>>
> >>>>>> Not confirmed to work with 8.6 afaik.
> >>>>>>   2012/6/21 Ke Carlton <[hidden email]>:
> >>>>>>> Based on reports, using odbc with FMSA is much faster.
> >>>>>>>  On Thursday, 21 June 2012, Johan Solve <[hidden email]> wrote:
> >>>>>>>> This is somewhat the same results I got when migrating an ancient FM6
> >>>>>>>> based site to FMS11 (intermediate migration in wait for a complete
> >>>>>>>> rebuild). FM6 on old G4 server hardware performed MUCH faster than
> >>>>>>>> FMS11 on today's hardware.
> >>>>>>>>  I had to do some serious cache juggling with cache priming and all to
> >>>>>>>> get decent performance. Layout optimizations didn't help much. It
> >>>>>>>> seems the Lasso FM SA connector burns a lot of time parsing and
> >>>>>>>> preparing the XML result since the raw response is, ehum, less slow.
> >>>>>>>>  I suspect FMS11 on Windows/IIS is one factor since the fairly old Mac
> >>>>>>>> dev server performed better than the Windows server used in
> >>>>>>>> production. We are experimenting with using FMS11 with Apache on
> >>>>>>>> Windows mainly to overcome the hard 60 seconds timeout in IIS that
> >>>>>>>> kills nightly maintenance routines. This setup is not supported by FMI
> >>>>>>>> but seems to work fine. Next step is to find out if performance is any
> >>>>>>>> better with that setup.
> >>>>>>>>  2012/6/20 Patrick Larkin <[hidden email]>:
> >>>>>>>>> The strange part is that It is roughly 3 times faster on a three server
> >>>>>>> Filemaker 6 setup (web server + Filemaker Unlimited + Filemaker Server 6)
> >>>>>>> with the Filemaker portion running on archaic G4 towers running 10.2.
> >>>>>>>>>  The new setup is web server _ Filemaker 10 Server Advanced running on a
> >>>>>>> quad-core Xeon Xserve running 10.5.  The databases were converted without
> >>>>>>> modification to the Filemaker 11 platform.  I expected a marked
> improvement
> >>>>>>> just on horsepower and OS improvements alone!  :)
> >>>>>>>>>  Patrick Larkin
> >>>>>>>>> Developer/Administrator of Special Systems / Webmaster
> >>>>>>>>> Bethlehem Area School District
> >>>>>>>>>     On Jun 20, 2012, at 3:36 PM, Tim Taplin wrote:
> >>>>>>>>>
> >>>>>>>>>> one way to get a look at what's happening throughout your page is using
> >>>>>>> some simple timers, however, it sounds like your issues are likely with
> the
> >>>>>>> Filemaker interaction and not within your lasso code.
> >>>>>>>>>>  simple timer:
> >>>>>>>>>> get the page start time in milliseconds
> >>>>>>>>>>     local('start' = date_msec);
> >>>>>>>>>> Anywhere you need to know the elapsed time, output this:
> >>>>>>>>>>     (date_msec - #start)+'ms';
> >>>>>>>>>>  by comparing the time elapsed from one code block to the next, you can
> >>>>>>> see how long each piece is taking and compare results if you experiment
> >>>>>>> with different layouts or methods of organizing your data and processing
> it.
> >>>>>>>>>>  It sounds like you may be in for some Filemaker hacking though.
> >>>>>>> reviewing each layout to make sure you have layouts that use properly
> >>>>>>> indexed fields, dont have extra fields on the layout that you are not
> >>>>>>> retrieving, etc. If I recall correctly, Filemaker seems to benefit
> >>>>>>> significantly from nested inlines, so you may want to wrap both inlines in
> >>>>>>> an outer inline or just simply nest the second inline inside the first
> (not
> >>>>>>> inside the records container ;)  ) and test to see if you get performance
> >>>>>>> gains from there.
> >>>>>>>>>>  In addition, you may wish to double check the Filemaker server setup
> to
> >>>>>>> make sure you have allowed enough resources, as the defaults are not
> >>>>>>> necessarily good for web interaction.
> >>>>>>>>>>  Tim Taplin
> >>>>>>>>>>  On Jun 20, 2012, at 12:02 PM, Patrick Larkin wrote:
> >>>>>>>>>>
> >>>>>>>>>>> Hello -
> >>>>>>>>>>>  I'm trying out some things with Lasso 8.6 and Filemaker 11.  The page
> >>>>>>> I'm working on loads significantly faster with Filemaker 6(!) and am
> trying
> >>>>>>> to track down what the issue might be.
> >>>>>>>>>>>  The page simply runs one inline to pull student demographics and
> >>>>>>> another inline from another database to pull a dozen other fields.  The
> >>>>>>> inlines put everything into variables which are then displayed in the page
> >>>>>>> using [var:'theVar'] tags.  Nothing at all unusual.
> >>>>>>>>>>>  What are some techniques people use?  I tried moving the [abort] tag
> >>>>>>> around but that only gets me so far.
> >>>>>>>>>>>   Patrick
> >>>>>>>>>>> #############################################################
> >>>>>>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>>>>> the mailing list Lasso
> >>>>>>>>>>> [hidden email]
> >>>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>>>>>  #############################################################
> >>>>>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>>>> the mailing list Lasso
> >>>>>>>>>> [hidden email]
> >>>>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>>>>>
> >>>>>>>>>  #############################################################
> >>>>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>>> the mailing list Lasso
> >>>>>>>>> [hidden email]
> >>>>>>>>> To unsubscribe, E-mail to: <--
> >>>>>>>> Mvh
> >>>>>>>> Johan Sölve
> >>>>>>>> ____________________________________
> >>>>>>>> Montania System AB
> >>>>>>>> Halmstad   Stockholm
> >>>>>>>> http://www.montania.se
> >>>>>>>>  Johan Sölve
> >>>>>>>> Mobil +46 709-51 55 70
> >>>>>>>> [hidden email]
> >>>>>>>>  Kristinebergsvägen 17, S-302 41 Halmstad, Sweden
> >>>>>>>> Telefon +46 35-136800 |  Fax +46 35-136801
> >>>>>>>> #############################################################
> >>>>>>>> This message is sent to you because you are subscribed to
> >>>>>>>> the mailing list Lasso
> >>>>>>>> [hidden email]
> >>>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>>>
> >>>>>>> #############################################################
> >>>>>>> This message is sent to you because you are subscribed to
> >>>>>>> the mailing list Lasso
> >>>>>>> [hidden email]
> >>>>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>>>> Send administrative queries to  <[hidden email]>
> >>>>>>  
> >>>>>  -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >>>>> Steve Piercy               Web Site Builder               Soquel, CA
> >>>>> <[hidden email]>                  <http://www.StevePiercy.com/>
> >>>>>  #############################################################
> >>>>> This message is sent to you because you are subscribed to
> >>>>> the mailing list Lasso
> >>>>> [hidden email]
> >>>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>>> Send administrative queries to  <[hidden email]>
> >>>>  #############################################################
> >>>> This message is sent to you because you are subscribed to
> >>>> the mailing list Lasso
> >>>> [hidden email]
> >>>> To unsubscribe, E-mail to: <[hidden email]>
> >>>> Send administrative queries to  <[hidden email]>
> >>>
> >>> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> >>> Steve Piercy               Web Site Builder               Soquel, CA
> >>> <[hidden email]>                  <http://www.StevePiercy.com/>
> >>>
> >>> #############################################################
> >>> This message is sent to you because you are subscribed to
> >>> the mailing list Lasso
> >>> [hidden email]
> >>> To unsubscribe, E-mail to: <[hidden email]>
> >>> Send administrative queries to  <[hidden email]>
> >>
> >> #############################################################
> >> This message is sent to you because you are subscribed to
> >> the mailing list Lasso
> >> [hidden email]
> >> To unsubscribe, E-mail to: <[hidden email]>
> >> Send administrative queries to  <[hidden email]>
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > Steve Piercy               Web Site Builder               Soquel, CA
> > <[hidden email]>                  <http://www.StevePiercy.com/>
> >
> > #############################################################
> > This message is sent to you because you are subscribed to
> > the mailing list Lasso
> > [hidden email]
> > To unsubscribe, E-mail to: <[hidden email]>
> > Send administrative queries to  <[hidden email]>
> #############################################################
> This message is sent to you because you are subscribed to
>   the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Steve Piercy               Web Site Builder               Soquel, CA
<[hidden email]>                  <http://www.StevePiercy.com/>

#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Ke Carlton-3
In reply to this post by stevepiercy
There was an article published with the hard numbers:

http://www.lassosoft.com/Accessing-FileMaker-PHP-vs-Lasso-9

Ke

On 21 June 2012 10:32, Steve Piercy - Web Site Builder
<[hidden email]>wrote:

> Jono provided an anecdotal claim that ODBC is faster than the Lasso
> Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>
#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: Ways to find cause for page delay

Carl Ketterling
That's a fantastic writeup and very useful information.
Thanks, Ke, for sharing.
Thanks, Jono, for testing and documenting.

In response to this text from Ke Carlton ([hidden email]) sent on
Wednesday, June 27, 2012 at 11:27 AM (+0100):

>There was an article published with the hard numbers:
>
>http://www.lassosoft.com/Accessing-FileMaker-PHP-vs-Lasso-9
>
>Ke
>
>On 21 June 2012 10:32, Steve Piercy - Web Site Builder
><[hidden email]>wrote:
>
>> Jono provided an anecdotal claim that ODBC is faster than the Lasso
>> Connector for FMS9 or FMSA on 8.6, but not any reproducible test results.
>>
>#############################################################
>This message is sent to you because you are subscribed to
>  the mailing list Lasso
>[hidden email]
>To unsubscribe, E-mail to: <[hidden email]>
>Send administrative queries to  <[hidden email]>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
12