- Feature Articles
- CodeSOD
- Error'd
- Forums
-
Other Articles
- Random Article
- Other Series
- Alex's Soapbox
- Announcements
- Best of…
- Best of Email
- Best of the Sidebar
- Bring Your Own Code
- Coded Smorgasbord
- Mandatory Fun Day
- Off Topic
- Representative Line
- News Roundup
- Editor's Soapbox
- Software on the Rocks
- Souvenir Potpourri
- Sponsor Post
- Tales from the Interview
- The Daily WTF: Live
- Virtudyne
Admin
and Bust the Buster that's jumBustin' your Trace
Admin
I'm afraid it was bad phrased. there was a table with articles and I took on Article after the other in an "outer" loop than I have waste places and did another loop for all the waste places. So a loop within a loop that's at least somewhere in the O(n²) area. And yes I did a trip to the database in every loop. So that was a terrible idea. However it was just meant to be run once and so I did not care but with enough articles and waste places it has come to a near grinding halt. (So it took maybe 30 minutes) to run for a certain customer....
It was simply brute force. But in the end it just turns out that with better use of informaton this could be cut down considerably. Still the code was written. So I wrote I'm guilty of writing it....
Admin
This whole nested mess could probably be easily converted so some very simple SQL.
Admin
Since you were pretty close already, I took the liberty of converting your comment into a Haiku.
Admin
I guess that makes you V-for-Vendetta's cousin Q? Wait, wasn't he supposed to be omnipotent or something? I'm all confused now...
-- Furry cows moo and decompress.
Admin
One Dilbert Cartoon sums it up: http://www.dilbert.com/2011-02-03/