Monday, May 25, 2009
Wednesday, May 20, 2009
The script runs as follows:
- Validate (check the file, database table exists etc.)
- Empty the database table
- Open the file
- For each line of the file:
- Read the line
- If its valid input:
- Generate the insertion query
- Run query and check for errors occured.
In principle this appears to be fine. However, submitting the script on a file with ~1 million entries causes it to run for approximately 10-15 mins afterwhich it just "stops" (left with a blank browser window, with no more loading signs). At this point, checking the number of rows in the database using PHPMyAdmin (or a COUNT SQL statement) reveals a number typically in the region of 600,000. Naturally, one imagines an error has occured, so one inspects the tables and scripts and repeats the exercise. Again, it appears to "fail", with less than the number of records being inserted. Repeat again, and again.
However, by stopping and checking the number of rows again (shortly after the script "fails") it is revealed that the row count has increased (e.g. to 650,000).
Checking a few minutes later shows that it has increased again (e.g. 750,000). Even though the script has apparently ended.
Leaving the system for another 10 mins or so reveals that the correct number of rows have been inserted into the database after all.
I don't really have any conclusions, but I can only think of two explanations: Either there's some form of insert query caching going on - which there shouldn't be.. or, there's some kind of message being sent to the browser which gives it the impression the script has died - even when it has not.
Has anyone come across this before? Anyone have any explanations?
Thursday, March 19, 2009
Monday, January 01, 2007
Wedding photos #2: Dave and Alison Huntingford
Originally uploaded by Jonnyboy2005.
Some photos from Dave and Alison's wedding have been put up on Flickr... unfortunately not many came out well, so there are only 6 for the timebeing (more may come later, if i'm able to rescue them!)
Follow this link to see the set:
Tuesday, December 19, 2006
Sunday, November 05, 2006
Thursday, September 07, 2006
Finally, the Bay View Systems (Ltd) site has been opened up for everyone to browse and plan how they're going to employ me :o)
Business will start formally on the Monday 2nd October. I've been accepted into the Digital Technium on the Swansea University campus, which is going to be great!
Feedback on the site would be appreciated. For those of you for whom I have an email address, i'll be sending you an email announcing the launch of the company, together with a services brochure sometime in the next week or so.