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

[Gjermund Gusland Thorsen]

Whatever you do

DO NEVER run server service over WLAN!!! That's really killing
performance, I run separate NICs for database looksups from webservers
and application servers over link nets ( netmask 255.255.255.252 ) for
ultimate performance.

ggt

2008/2/4, Steve Winter <steve at bluecrocodile.co.nz>:
>
>
>
>
> 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
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>