[FX.php List] Disappointing results in migration to FM8 & FX.php

[Matthew White]

Hey all, a couple of thoughts.

One, We have purchased The zend development environment.  One of the nice
tools is a profiler, which will lay out all the script steps etc to analyze
where your performance hits are coming.

Two, I have performed queries of >1 million records through the web
interface with fx.php and got results back in <5 seconds, so there should be
a solution to your problem.


If you haven't done so already, use the direct xml interface to perform the
query and see what your return time looks like.

Just an overall thought, I am very pleased with the high end of response
times from FMSA 8, my only complaint is that the min response time is ~.5
seconds.  That may not seem like much, except we have created various perl
and python utilities that use php web services utilizing FMSA as a backend.
One is a logging tool and when we tried debug level logging (i.e. 10 inserts
in the log db in fm per second, per thread, 3 threads) we totally chocked
the dev version of FMSA, it returned "too many users" errors from FSMA.
Ickey. 

In addition, if you are performing a parallel series of operations in one
script, the delay for each operation is painful. Leading to script run times
that are 5-10 seconds.  Not ideal for a client application.



Matt



On 3/19/06 7:27 PM, "Bob Patin" <bob at patin.com> wrote:

> Another thought: I just opened the database remotely and did a search
> for "music" within the "article" field, and it took less than a
> second... so thankfully, it doesn't appear to be a server-related issue.
> 
> Bob
> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-- 
Matt White
Director Of Development
SciMed Solutions
(919) 287-1817
(919) 540-3283 (Voice Mail, Pager)
matt at scimedsolutions.com