Speeding up FX.php

fx.php

November 9, 200520 yr

I want to bring back the topic of speeding up FX.php

So far my solution is working acceptable, however there are time that I think there are tricks I might use to speed things up. Compared to our CDML solution, the speed is noticably slower.

What are ways to speed up PHP?

November 9, 200520 yr

It may just need a more powerful processor. That sounds a bit simple, however FX is using XML recordsets which are much "bulkier" than CDML recordsets.

That is about the best I can offer at the moment :

All the best.

Garry

November 10, 200520 yr

Author

Here is an update on my search.

To speed up FX.php consider:

1. FX.php allows the use of MySQL caching. Apparently that can make searching blazing fast, but may not be for the faint of heart.

2. Create seperate layouts for each query and only have fields related to that query on that layout.

3. Ensure that all fields being searched on are indexed.

4. There are PHP accelerators available for Linux and Open BSD that speed up PHP between 1-10 times. The Windows accelerators may not be that available yet.

If anyone knows of PHP accelerators or has comments on these points, feel free to add to them.