Huge amount of records in FM db

[redcoder]

Anyone know a tricky and simple way to display huge amount of records from FM to webage using PHP?

I managed to fetch the records (about 98 records in table 1) to webpage using PHP.I use ODBC connection and i use FM pro 8.5 trial version.

My problem is that I have a huge records(> 200000) records in a table 2. When I try to fetch it to webpage as i did with table 1, it display fatal error saying maximum execution time exceeded. I try to increase the time in php config file from 50 to 300s, but still getting the error.

I know FX.php or FM PHP API beta version could be of help but it require FM advanced version which do not have trial version and my employer does not have budget for this.

Someone please help me on this.

[redcoder]

It run for a long time until my Apache crashed and forced to shut down..

[Genx]

Hi -- Can I ask as to what purpose you want to display 200,000 records at once for?

[redcoder]

Actually I want to read a records from FM and insert or may be update into MySQL.

Therefore I want to make sure the records is read by displaying it on the web page.

[Genx]

I want to make sure the records is read by displaying it on the web page....

The process will take about 100 times longer if you actually display the code.

[redcoder]

What would you recommend?

[redcoder]

Is that mean it would be better if I read and insert the record straight into mySQL(as a background processing) without display it?

[Genx]

Well, I would recommend you just script this from FM using the Execute SQL statement...

[redcoder]

Do you mean I can fetch the record from FM to MySQL by scripting in FM Scriptmaker?

How is it done? Sorry for the fundamental question as I am a beginner in FM.

Edited June 13, 2007 by Guest

[redcoder]

My main objective is to transfer records from FM to MySQL. I know there are tools out there to migrate from FM to MySQL, but still it involve a cost.

[Genx]

No -- I mean...

In FileMaker, there is a step called execute SQL .. as in you can cycle through FileMaker records, build sql commands and execute them...

In FileMaker Press F1, and go to the function reference -> Scripts and lookup Execute SQL statement.

[Genx]

Okay, I only saw your second post...

It's not overly difficult but i don't have time to put the sample together right now -- I'll try post one for you on Friday if no one else has helped you out by then.

[redcoder]

Alright.. no problem..

thanks in advance