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

[Bob Patin]

I've got a database that has been online for years in FileMaker 6  
using CDML; the database is a series of articles, only about 360  
records. Some of the articles are rather long, but most are in the  
500-word range, if I were to guess.

I decided to migrate this client to FileMaker 8 and FX.php, so I have  
both databases on my servers, and can test the 2 side by side. Here  
are my extremely disappointing results:

This is a musician's union site, so almost all the articles have the  
word "music" in them. When I search for "music" in the databases,  
here are the times:

FM 6 Server/CDML: 4 seconds to find 340 records
FMSA 8/FX.php: 40 seconds to find 340 records

Same web server (Mac OS X Server Tiger), same network, different  
FileMaker server machines, of course, but the FM 6 Server is actually  
a much slower machine. The FM 6 databases are in a RAIC, which  
connects to FileMaker 6 Server.

I checked to make sure the field is indexed, which it is; I even  
tried creating a new layout with just the necessary fields on it. I  
saved a compacted version of the FM8 database, put it on the server;  
unfortunately, it didn't help much.

Any thoughts? Is this just the way it's going to be when searching  
long articles across several hundred records? If so, why it is so  
much slower in FX.php than it is in CDML?

Thanks,

Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com

   CONTACT US VIA SKYPE:
      USERNAME: longtermsolutions

   CONTACT US VIA INSTANT MESSAGING:
      AIM or iChat: longterm1954
      Yahoo: longterm_solutions
      MSN: bob at patin.com
      ICQ: 159333060