[FX.php List] How much traffic can it take?

[Steve Winter]

Hi Jamie,

 

To be honest, I'd doubt it. especially if you've got multiple auctions all
ending at the same time. 

 

Even if you separate your web-server from your filemaker server, optimise
your code down as far as possible, minimise the number of calls to the
database (and do extra post-processing by PHP), etc, the single threaded
nature of the XML interface will likely as not still be your undoing.

 

I built a solution a while back which always had 10 simultaneous users,
doing lots of different things, requiring lots of hits on the db. I had FMS
running on one machine, Apache on another, all delivered over a 54Mb
wireless LAN and there were still times when there were visible delays in
getting data to users.

 

If I were looking to do something like this I'd be inclined to look at ways
to integrate a MySQL database for the site, with the live inventory data
to/from FileMaker.

 

YMWV (your millage will vary ;-)

 

Cheers

Steve

 

  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jamie Adams
Sent: 04 February 2008 17:57
To: fx.php_list at mail.iviking.org
Subject: [FX.php List] How much traffic can it take?

 

Hello all-

 

My company is considering building an auction script (like a private eBay)
for some inventory in our FileMaker database.  One suggestion from our team
was to build PHP auction scripts that connect directly to our FileMaker DB.
However, I've observed that the performance of FileMaker with FX.php is not
quite as good as MySQL in many circumstances.  Near the end of an auction,
we might have as many as 40 bidders hitting the database with quick
succession.  Can FX.php take this kind of abuse?  Or do I need to look into
exporting to MySQL?  I'm going to try some tests myself, but I hoped to draw
from the collective wisdom first.  I've learned some tricks for optimizing
my FX.php code to load quicker, but I've never tested under such a heavy
load.

 

 

Jamie Adams

________________________________________________________

 

Liquis, Inc.

 

400 Parker Drive, Suite 1110, Austin, TX 78728

phone 512.299.9634, ext 103 -- fax 512.873.0575

________________________________________________________ 

 

www.liquis.com

www.auctionpartner.com

www.furniture-partner.com

eBay Store:
<http://stores.ebay.com/Auction-Partner-High-Tech-Equipment?refid=store>
http://stores.ebay.com/Auction-Partner-High-Tech-Equipment?refid=store

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080204/abf6dc64/attachment.html