How many, how often

[mwookie]

I am finding that my shared web server is having a hard time handling to many links being processed at a time. I am down to 10 links every thirty minutes. I am on a shared server with Hostgator. Anyone else finding it hard to keep up?

"You cannot escape the responsibility of tomorrow by evading it today." Abraham Lincoln
Company (http://www.iriselements.com) – Projects (Cheap Stock Photos (http://www.imagetrail.net) – Directory of New Mexico Cities (http://www.newmexicodirect.net))

[Michael Hill]

Hello, mvookie,

Probably, you have loop in your flat_structure table. This appears, when your A category has B as parent, and B in it's turn has A as parent. In this case your table contains great number of rows with the same `id_parent` and `id_category`.

Is your flat_structure table correct?

[mwookie]

Hmm... I am not sure. I have moved some things around and then I noticed that counts, etc were off so you may be right. Can I empty the table and rebuild it somehow?


There has got to be a script or query to rebuild it.

________________
"You cannot escape the responsibility of tomorrow by evading it today." Abraham Lincoln
Company (http://www.iriselements.com) – Projects (Stock Image Search Engine (http://www.imagetrail.net) – Sell Your Photos (http://www.microstockforum.com))

[mwookie]

I found the script to redo the flat structure, but hade no change in the script.

For others who have a slow or non-moving cron problem, I found that if you change header.inc.php (in the cron directory) to favor cURL over fopen, it made it possible to process some urls that the other method would not.

________________
"You cannot escape the responsibility of tomorrow by evading it today." Abraham Lincoln
Company (http://www.iriselements.com) – Projects (Stock Image Search Engine (http://www.imagetrail.net) – Sell Your Photos (http://www.microstockforum.com))

[Mark Brookes]

Hello, mvookie,
Is your flat_structure table correct?
Hello Michael

Could you tell us the official description of what the flat_structure table should contain, and perhaps an example.

Thanks
Mark

[GrayTap]

Yes Please!
I just dumped my directory to work on a template on my pc and noticed it was 18mb, and Table: flat_structure, Showing rows 0 - 29 (416,261 total, Query took 0.0004 sec)

416,261!!! that's one big loop and I only changed templates I got from here!

over 4 hundred thousand of these entries for
Total number of links: 4
Total number of categories: 123

I know it's free and greatly appreciate all the work done on it as I to am a php/mysql developer but what a bug!

can this be emptied for now?

Thnaks!

[GrayTap]

i figured it out I had two categories that where there own parents. all fixed!
how does this happen?