| Registered: April 9, 2007 |  Posts: 8 |
| | Posted: | | | | Exporting to XML is cool enough. Also importing from XML file in phpMyProfiler with a parser script is cool enough. But timeout issues with the parser script seems to be somewhat common. The existing parser do allow splits of the XML, but that does really not help as the parser script empties the database everytime the script is executed. The result is timeouts before the script has finished parsing.
My question / wish is that if DVDprofiler could export all data to a sql file it is extremely simple to do some sql queries and also splitting the sql file to prevent timeouts.
I do not now if exporting to sql is completely nuts or a heavy task to program, but it is just a helpful feature for me if possible. Please vote!
Kindly
Carsten Petersen |
|
| Registered: March 13, 2007 | | Posts: 793 |
| | Posted: | | | | Quoting goAMinD: Quote:
But timeout issues with the parser script seems to be somewhat common. The existing parser do allow splits of the XML, but that does really not help as the parser script empties the database everytime the script is executed. The result is timeouts before the script has finished parsing.
I don't know what version of phpDVDProfiler you are using, but the project has been abandoned, as far as I know, by the original developer, but has been picked up by Fredlooks (among others), to continue development of it. Now, the timeout issue is not "fixed" per se, but you can run the update successively and it will eventually complete it, as long as you don't have the "Complete Update" checkbox ticked. The database is cleaned only when the Complete Update checkbox is ticked (or when you update the schema). EDIT: Oh my.. my bad! You are talking about php MyProfiler, I thought you were talking about php DVDProfiler.. Sorry! | | | | Last edited: by RossRoy |
|
| Registered: March 14, 2007 | Reputation:  |  Posts: 6,744 |
| | Posted: | | | | The last time I uploaded with phpMyProfiler the script chunked the xml into pieces of 50 DVDs and then inserted them into the DB. The script didn't restart though and therfore inserted all DVDs without cleaning the DB in-between. | | | Karsten
DVD Collectors Online
 |
|
| Registered: April 9, 2007 | | Posts: 8 |
| | Posted: | | | | Quoting DJ Doena: Quote:
The last time I uploaded with phpMyProfiler the script chunked the xml into pieces of 50 DVDs and then inserted them into the DB. The script didn't restart though and therfore inserted all DVDs without cleaning the DB in-between. Yeah, I tried the splitting too (25, 30, 50 even 10 and less) and some DVD's are also inserted in the DB, but not all split XML's are finished. I always get the timeout... sometimes after 60, 80, 125 inserted DVD's. I also tried changing php.ini settings to: max_execution_time 300max_input_time 300Those settings didn't help either. | | | | Last edited: by goAMinD |
|
| Registered: March 13, 2007 |  Posts: 525 |
| | Posted: | | | | As I recall, apache has its own versions of those 2 variables. Worth playing with those.
That's assuming you do the update from the web rather than from a shell. | | | 
Home of the phpDVDProfiler forums |
|
| Registered: April 9, 2007 | | Posts: 8 |
| | Posted: | | | | Please feel free to comment your votes. Maybe it answers some of my questions or at least helps me to understand why. |
|