[FX.php List] [OFF] Duplicate Record in different Table

[Bob Patin]

I'm doing a project now with scripts; it's the first time I'm using  
them, but it's the fastest way.

In a database with a over 200,000 records, I pull in 1400 or so  
records in a script, go thru them, sort them by department, count each  
dept., get a sum of some other variables for each department, and then  
write all of this into a single field. I pull that back to the web  
using a simple URL that runs the script, and then construct graphs  
using the returned data.

Compared to doing all of this on the web, it's tons faster; I have to  
credit my collaborator on this project with the testing and decision  
to use scripts rather than all-PHP in the design. When tests were run,  
it was obvious that scripts were the way to go. Also, it's a lot  
faster and easier to construct the queries in scripting rather than in  
PHP, because of the tests I have to do on the data as I'm looping thru  
the foundsets.

Bob Patin
Longterm Solutions LLC
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
Twitter: bobpatin
iChat/AIM: bobpatin
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance & TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting



On Jan 6, 2009, at 2:47 PM, Jonathan Schwartz wrote:

> It's been pounded in my head not to use scripts.
>
> That being said, I went ahead and did it the brute force way.
>
> I just know that S Winter will come along and give me a 6 line jewel  
> when the sun rises in London.
>
> J