[FX.php List] Are there any FMCakeMix war stories?

[Nick]

I should add that when the site was sluggish, pages that didn't use the
findquery were quick. (this was before caching anything)

On Wed, Apr 11, 2012 at 11:59 AM, Nick <whatdoyouwant at gmail.com> wrote:

> I have a site that can be sometimes heavily used.  I was running around up
> to 9 regular queries and a more involved findquery.  When someone would
> refresh the page with the findquery on it, the cpu would spike in relation
> to how fast they hit the refresh button.  When the cpu was high, the site
> would be slow.
>
> When you look at the client list in filemaker, it would show a few
> connections by the fx user and one or more as having been logged in for
> more than a few minutes.  Killing the connection then would make the site
> fast again.
>
> Making more fx users to reduce volume of requests per user seemed to
> alleviate the problem a little.  Caching most of the queries (obviously)
> fixed the problem even more.
>
> The site couldn't be faster now.
>
> On Sun, Mar 18, 2012 at 1:29 PM, Denis Somar <dsomar at gmail.com> wrote:
>
>> Nick,
>>
>> This is really interesting and I'm really curious as to how you
>> arrived at this best practice ?
>>
>> Cheers,
>> Denis
>>
>> On Sun, Mar 18, 2012 at 12:03 PM, Nick <whatdoyouwant at gmail.com> wrote:
>> > No, only a separate one for using findquery.  Findquery queues a number
>> of
>> > actions in one large query, and the filemaker user you are querying
>> with can
>> > make other findquery actions wait.  It really depends on the volume.
>> >
>> >
>> > On Tue, Mar 13, 2012 at 7:08 AM, BEVERLY VOTH <beverlyvoth at gmail.com>
>> wrote:
>> >>
>> >> Yes, Nick, what do you mean by "separate"? Do you create more than one
>> >> user for the queries, or just a separate one for finds, ( and one for
>> adds,
>> >> edits, deletes )? If so, how does that help ( to have more than one
>> account
>> >> to access the database when web publishing )?
>> >>
>> >> Beverly
>> >>
>> >>
>> >> On 12 Mar 2012, at 10:20 PM, Nick Salonen wrote:
>> >>
>> >> > In FileMaker, a user that has fmxml privilege to make queries.
>> >> >
>> >> > Sent from my iPhone
>> >> >
>> >> > On Mar 12, 2012, at 12:03 PM, BEVERLY VOTH <beverlyvoth at gmail.com>
>> >> > wrote:
>> >> >
>> >> >> Nick, can you expound on this statement "separate user" ?
>> >> >>
>> >> >> Thank you,
>> >> >> Beverly
>> >> >> On 12 Mar 2012, at 12:52 AM, Nick wrote:
>> >> >>
>> >> >>> I usually make a separate user for findquery requests.
>> >> _______________________________________________
>> >> FX.php_List mailing list
>> >> FX.php_List at mail.iviking.org
>> >> http://www.iviking.org/mailman/listinfo/fx.php_list
>> >
>> >
>> >
>> > _______________________________________________
>> > FX.php_List mailing list
>> > FX.php_List at mail.iviking.org
>> > http://www.iviking.org/mailman/listinfo/fx.php_list
>> >
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20120411/92424e37/attachment.html