Jump to content

Recommended Posts

Awesome work with Bertha, Kev. Was there copious use of the DELETE statement?

 

Damn, I miss database nerding. I don't have enough of it to do at home.

heh luckily all the DELETE statements were automated, lord only knows how many queries were run the other night must have been in the 30 or 40 thousands, i'm not sure why it's quite so many seems to take like 10 queries to delete a thread, next time i'll investigate.

 

the fun bit was optimizing the tables cos they're too big for the OPTIMIZE query to not crash bertha so i have to do it via command line on the files directly instead

Link to comment
Share on other sites

heh luckily all the DELETE statements were automated, lord only knows how many queries were run the other night must have been in the 30 or 40 thousands, i'm not sure why it's quite so many seems to take like 10 queries to delete a thread, next time i'll investigate.

 

the fun bit was optimizing the tables cos they're too big for the OPTIMIZE query to not crash bertha so i have to do it via command line on the files directly instead

 

you what?

Link to comment
Share on other sites

Dear Kev, I might use a gif for my signature but you might ask me to take it down like it happened in 2006.

 

 

What shall I do? is big gifs still an issue for Bertha?

 

I'm guessing it's not really a bertha issue as images are usually hosted on other websites and merely linked to, but the size limit is designed to stop people with slow connections who don't want to turn images off from having to wait ages for a page to load. I had nearly a megabyte of images in my sig once, and imagine how long they took to load after several posts on the same page :LOL:

Link to comment
Share on other sites

heh luckily all the DELETE statements were automated, lord only knows how many queries were run the other night must have been in the 30 or 40 thousands, i'm not sure why it's quite so many seems to take like 10 queries to delete a thread, next time i'll investigate.

 

the fun bit was optimizing the tables cos they're too big for the OPTIMIZE query to not crash bertha so i have to do it via command line on the files directly instead

 

Ah, have you got a set of pruning scripts ready that you can just kick off as needed? Ace.

 

I always had to be careful about when I scheduled optimization jobs on our accounting databases because they took ages and locked tables, interfering with backups and other jobs.

Link to comment
Share on other sites

That was the first time I've ever had that message, and when I go back to the url it's still there. It loads the page, but the warning comes up after a couple of seconds.

thats weird, would you be able to go through to that page and then right click on it and select view page source and paste it in [noparse]


[/noparse] tags here for me?

Link to comment
Share on other sites

The post was almost 8000 characters over the limit :LOL: how much do you want me to cut off?

oh ha well all i was going to do was search for that url that it mentions on the malware page, so instead could you just go to view page source then search it (ctrl + f) for that malware url and if it finds something paste me like 10-15 before it to 10-15 lines after. but i expect the search will fail

Link to comment
Share on other sites

					Originally Posted by <strong>Static Shadows</strong> 
				<a href="showthread.php?p=3985427#post3985427" rel="nofollow"><img class="inlineimg" src="images/never/buttons/viewpost.gif" border="0" alt="View Post" /></a> 
			</div> 
			<div style="font-style:italic"><img src="images/smilies/eek.gif" border="0" alt="" title="Eek!" class="inlineimg" /> What has that Matt been doing to Jimmy?</div> 

	</td> 
</tr> 
</table> 
</div>just too much spaff. <br /> 
<br /> 
its all sorted now with your cleanning device lolz.<br /> 
<br /> 
<img src="http://www.robotian.co.kr/robot/data/I/koi_robot.jpg" border="0" alt="" /><img src="images/smilies/happy.gif" border="0" alt="" title="Happy" class="inlineimg" /> 
	</div> 
	<!-- / message --> 






	<!-- sig --> 
		<div> 
			__________________<br /> 
			<div class="signature"> 
				<div align="center"><img src="http://i94.photobucket.com/albums/l98/si350/HAARPimage3.jpg" border="0" alt="" /></div><div align="center"><a href="http://board.muse.mu/showthread.php?t=43968&highlight=Judderman" target="_blank"><font face="Arial Black"><b><font size="5"><font color="#fa1955">e</font><font color="#fa2452">l.</font><font color="#fa304f">o</font><font color="#fa3b4c">h.</font><font color="#fa474a">v</font><font color="#fa5247">ee.</font><font color="#fa5e44">e</font><font color="#fa6941">ee.</font><font color="#fa743e">b</font><font color="#fa803b">e</font><font color="#f98b39">e.</font><font color="#f99736">o</font><font color="#f9a233">h.</font><font color="#f9ad30">a</font><font color="#f9b92d">y</font><font color="#f9c42a">.</font><font color="#f9d028">t</font><font color="#f9db25">e</font><font color="#f9e722">a</font></font></b></font></a></div> 
			</div> 
		</div> 
	<!-- / sig --> 

 

			<div style="margin:20px; margin-top:5px; "> 
<div class="smallfont" style="margin-bottom:2px">Quote:</div> 
<table cellpadding="6" cellspacing="0" border="0" width="100%"> 
<tr> 
	<td class="alt2" style="border:1px inset"> 

			<div> 
				Originally Posted by <strong>judderman</strong> 
				<a href="showthread.php?p=3985440#post3985440" rel="nofollow"><img class="inlineimg" src="images/never/buttons/viewpost.gif" border="0" alt="View Post" /></a> 
			</div> 
			<div style="font-style:italic">just too much spaff. <br /> 
<br /> 
its all sorted now with your cleanning device lolz.<br /> 
<br /> 
<img src="http://www.robotian.co.kr/robot/data/I/koi_robot.jpg" border="0" alt="" /><img src="images/smilies/happy.gif" border="0" alt="" title="Happy" class="inlineimg" /></div> 

	</td> 
</tr> 
</table> 
</div>Awww.. he's such a sweet little Koi <img src="images/smilies/happy.gif" border="0" alt="" title="Happy" class="inlineimg" /> 
	</div> 
	<!-- / message --> 






	<!-- sig --> 
		<div> 
			__________________<br /> 

 

From the looks of that, the inflatable koi picture is linked from that site.

Link to comment
Share on other sites

ah yes it has to be that! have you set your view to be more posts per page than normal then? cos it appears on page 3 for me which explains why i couldn't replicate the problem at all or find any references in the code for the requested page. oh well i'll delete that image so other chrome users aren't affected.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...