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

[Nick]

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/c34d0fde/attachment.html