<?xml version="1.0" encoding="UTF-8"?><rss version="2.0"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:atom="http://www.w3.org/2005/Atom"
	xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
	xmlns:slash="http://purl.org/rss/1.0/modules/slash/"
	>

<channel>
	<title>Fred&#039;s Blog - Fr3d.org</title>
	<atom:link href="http://www.fr3d.org/feed/" rel="self" type="application/rss+xml" />
	<link>http://www.fr3d.org</link>
	<description></description>
	<lastBuildDate>Tue, 18 Jul 2017 00:01:39 +0000</lastBuildDate>
	<language>en-US</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
	<generator>http://wordpress.org/?v=4.2.15</generator>
	<item>
		<title>Folding@Peer1</title>
		<link>http://www.fr3d.org/2011/04/folding-at-peer1/</link>
		<comments>http://www.fr3d.org/2011/04/folding-at-peer1/#comments</comments>
		<pubDate>Mon, 04 Apr 2011 20:08:28 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[Cloud]]></category>
		<category><![CDATA[Folding]]></category>
		<category><![CDATA[GPU]]></category>
		<category><![CDATA[Peer1]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=2302</guid>
		<description><![CDATA[A colleague of mine started running Folding@Home on a few PCs in his office last summer. When a load of powerful servers were freed up after a cancellation at the end of last year, I figured that since we now had a lot of spares in the datacentre doing nothing, why not see what kind [&#8230;]]]></description>
				<content:encoded><![CDATA[<p><a title="GPU Folding Servers" href="http://www.fr3d.org/wordpress/wp-content/uploads/2011/04/IMG_0522-crop.jpg" rel="lightbox[2302]"><img class="alignright size-medium wp-image-2318" title="GPU Folding Servers" src="http://www.fr3d.org/wordpress/wp-content/uploads/2011/04/IMG_0522-crop-224x300.jpg" alt="GPU Folding Servers" width="224" height="300" /></a>A colleague of mine started running <a title="Folding@Home" href="http://folding.stanford.edu/" target="_blank" rel="noopener">Folding@Home</a> on a few PCs in his office last summer. When a load of powerful servers were freed up after a cancellation at the end of last year, I figured that since we now had a lot of spares in the datacentre doing nothing, why not see what kind of <acronym title="Points Per Day">PPD</acronym> we could squeeze out of them.</p>
<p>Originally we started out with a little over sixty dual-5420/5520 Xeon servers working on some <a style="text-decoration: none;" href="http://reviewimo.com/ubee-ddw365-review/"> <span style="text-decoration: none; color: #3d3d3d;">ubee ddw365</span></a>&#8216;s (8-12GB RAM each) running one instance of the regular CPU client for each CPU core. This gave a big boost to our rankings, going from&#8230; a very low number to the mid-2000s pretty quickly.</p>
<p>As the 5420/5520 servers were used up by new orders (and as we bought more powerful servers), I started running the <acronym title="Symmetric Multi-Processing">SMP</acronym> client (with the -bigadv option to increase the PPD) on a few Dell PowerEdge R810 servers (each with four quad-core <acronym title="HyperThreading">HT</acronym>-capable Xeons – a staggering 32 logical cores per server), which resulted in an enormous PPD increase.</p>
<p>We later had a bunch of <a title="Peer1 Hosting - GPU Cloud Computing" href="http://www.peer1hosting.co.uk/hosting/gpu-cloud-computing" target="_blank" rel="noopener">GPU Cloud servers</a> sent over from another datacentre, each with two 5620 Xeons, between 12 and 48GB RAM and two nVidia Fermi GPUs (pictured). With sixteen of these servers running two GPU Folding clients <strong>and</strong> the CPU SMP client (again with the -bigadv option), we shot up the team rankings, going from the low 1000s in early January to our current position of <strong>232<sup>nd</sup> worldwide</strong>! And we&#8217;re still climbing&#8230; <img src="http://s.w.org/images/core/emoji/72x72/1f600.png" alt="😀" class="wp-smiley" style="height: 1em; max-height: 1em;" /> (Update: 168<sup>th</sup> as of 7 Dec 2011)</p>
<p>Some stats, graphs and point/ranking predictions can be seen on the <a title="Official Stanford Folding@Home Stats page for Peer1_Hosting" href="http://fah-web.stanford.edu/cgi-bin/main.py?qtype=teampage&#038;teamnum=193402" target="_blank" rel="noopener">official Folding@Home stats page</a>, the <a title="Extreme Overclocking Stats for Peer1_Hosting" href="http://folding.extremeoverclocking.com/team_summary.php?s=&#038;t=193402" target="_blank" rel="noopener">Extreme Overclocking stats</a> tool or the <a title="Kakao Stats for Peer1_Hosting" href="http://kakaostats.com/tsum.php?t=193402" target="_blank" rel="noopener">Kakao Stats</a> tool.</p>
<p>The power usage of these servers is also pretty phenomenal; each GPU servers uses a little over 2amps (at ~240VAC) when running at 100% CPU/GPU load, which equates to just under 40 amps for all sixteen . If you are a pro gamer or you work at <a style="text-decoration: none;" href="https://gamingbuff.com"> <span style="text-decoration: none; color: #3d3d3d;">gamingbuff.com</span></a>, then you know how great these stats are for GPU combined with <a style="text-decoration: none;" href="https://www.hotrate.com/electronics/gaming/best-cpu-processor-for-gaming/"><span style="text-decoration: none; color: #333;">our round-up of the best gaming cpus</span></a> you can run almost any game existing. Each R810 uses about 4amps at full load (2amps per PSU) while the dual-5420/5520 servers only use approximately 1amp each.</p>
<p>And of course, with big power usage comes big heat output: each GPU server throws out an epic amount of hot air at over 50°C (122°F). You could heat a pretty big room with a single one of these GPU servers&#8230; as long as the occupants didn&#8217;t mind the horrendous noise the fans make at full speed.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2011/04/folding-at-peer1/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Automated Telnet Login with PuTTY and VBScript</title>
		<link>http://www.fr3d.org/2011/04/automated-telnet-login-with-putty-and-vbscript/</link>
		<comments>http://www.fr3d.org/2011/04/automated-telnet-login-with-putty-and-vbscript/#comments</comments>
		<pubDate>Sun, 03 Apr 2011 22:31:03 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[PuTTY]]></category>
		<category><![CDATA[Telnet]]></category>
		<category><![CDATA[VBScript]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=2300</guid>
		<description><![CDATA[I was getting tired of typing my username and password tens of times a day to login to various network devices, so after a bit of Googling, I found this post, which shows how to automate the login for a Cisco router. After adapting the code a bit, I had a script I could integrate [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>I was getting tired of typing my username and password tens of times a day to login to various network devices, so after a bit of Googling, I found <a title="Automated PuTTY Session to a Cisco Router via VBscript" href="http://www.cxliv.org/2008/01/16/automated_putty_session_to_a_cisco_router_via_vbscript.php">this post</a>, which shows how to automate the login for a Cisco router.</p>
<p>After adapting the code a bit, I had a script I could integrate into my existing <a title="The open-source keystroke launcher" href="http://www.launchy.net/" target="_blank">Launchy</a> setup to let me specify the switch/router IP address on the command line:</p>

<div class="wp_syntax"><table><tr><td class="code"><pre class="vb" style="font-family:monospace;"><span style="color: #151B8D; font-weight: bold;">Dim</span> sHostname
sHostname = WScript.Arguments.Item(0)
<span style="color: #151B8D; font-weight: bold;">set</span> WshShell = WScript.<span style="color: #E56717; font-weight: bold;">CreateObject</span>(<span style="color: #800000;">&quot;WScript.Shell&quot;</span>)
WshShell.Run <span style="color: #800000;">&quot;C:\Windows\ssh.exe -telnet &quot;</span> &amp;amp; sHostname
WScript.Sleep 500
WshShell.AppActivate sHostname &amp;amp; <span style="color: #800000;">&quot; - PuTTY&quot;</span>
WshShell.SendKeys <span style="color: #800000;">&quot;username{ENTER}&quot;</span>
WScript.Sleep 250
WshShell.SendKeys <span style="color: #800000;">&quot;password{ENTER}&quot;</span>
WScript.Sleep 500
WshShell.SendKeys <span style="color: #800000;">&quot;en{ENTER}&quot;</span>
WScript.Sleep 250
WshShell.SendKeys <span style="color: #800000;">&quot;enablepassword{ENTER}&quot;</span>
WScript.Sleep 500
WshShell.SendKeys <span style="color: #800000;">&quot;conf t{ENTER}&quot;</span></pre></td></tr></table></div>

<p>The commands in the code above work with the Foundry, Brocade and Cisco switches/routers where I work, so may require some modification to make it work with other devices.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2011/04/automated-telnet-login-with-putty-and-vbscript/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>iTunes Shift+Click Update/Restore Not Working</title>
		<link>http://www.fr3d.org/2010/09/itunes-shift-click-update-restore-not-working/</link>
		<comments>http://www.fr3d.org/2010/09/itunes-shift-click-update-restore-not-working/#comments</comments>
		<pubDate>Tue, 07 Sep 2010 20:43:59 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[iOS]]></category>
		<category><![CDATA[iTunes]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=540</guid>
		<description><![CDATA[After trying on multiple computers, with various versions of iTunes (all on Windows 7 though), I started to think that Apple had removed the Shift+Click Update/Restore functionality from iTunes, and I use it for my kid&#8217;s iPhone and my iPod that he uses as his favorites toys from the compiled a great list of electronic [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>After trying on multiple computers, with various versions of iTunes (all on Windows 7 though), I started to think that Apple had removed the Shift+Click Update/Restore functionality from iTunes, and I use it for my kid&#8217;s iPhone and my iPod that he uses as his  favorites  toys  from the <a style="text-decoration: none;" href="https://www.top9rated.com/electronics-gadgets/kids-toys/"><span style="text-decoration: none; color: #333;">compiled a great list</span></a> of electronic toys he has.</p>
<p>However, running iTunes as an Administrator &#8220;fixes&#8221; the Shift+Click function, allowing you to update or restore a new/custom firmware to your iOS device.</p>
<p>You need to find the actual iTunes.exe (in C:\Program Files\iTunes\ or C:\Program Files (x86)\iTunes\ for 64-bit Windows), as all the normal shortcuts (Start menu, desktop, taskbar, etc) are shell links rather than normal shortcuts and don&#8217;t allow you to start as an administrator.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/09/itunes-shift-click-update-restore-not-working/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>ActionFTP 1.1.0.1</title>
		<link>http://www.fr3d.org/2010/08/actionftp-1101/</link>
		<comments>http://www.fr3d.org/2010/08/actionftp-1101/#comments</comments>
		<pubDate>Sun, 29 Aug 2010 00:34:08 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[ActionFTP]]></category>
		<category><![CDATA[Software]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=531</guid>
		<description><![CDATA[I&#8217;ve uploaded a new version of of ActionFTP, my add-in for WindowClippings. This is mainly a bug-fix release, though I did include two new features: Added the imgftw.net image upload service The bit.ly URL shortening service can now be used, though it requires a (free) API key from their website See the ActionFTP page for [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>I&#8217;ve uploaded a new version of of <a title="ActionFTP" href="/actionftp/">ActionFTP</a>, my add-in for <a title="WindowClippings" href="http://www.windowclippings.com/" target="_blank">WindowClippings</a>.</p>
<p>This is mainly a bug-fix release, though I did include two new features:</p>
<ul>
<li>Added the <a title="imgftw.net" href="http://www.imgftw.net" target="_blank">imgftw.net</a> image upload service</li>
<li>The <a title="bit.ly" href="http://bit.ly/" target="_blank">bit.ly</a> URL shortening service can now be used, though it requires a (free) API key from their website</li>
</ul>
<p>See the <a title="ActionFTP" href="/actionftp/">ActionFTP</a> page for the download link and the full list of changes and fixes.</p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/08/actionftp-1101/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Exchange 2010 Installation &#8211; Management Shell Error</title>
		<link>http://www.fr3d.org/2010/08/exchange-2010-installation-management-shell-error/</link>
		<comments>http://www.fr3d.org/2010/08/exchange-2010-installation-management-shell-error/#comments</comments>
		<pubDate>Sun, 08 Aug 2010 00:53:46 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[Exchange]]></category>
		<category><![CDATA[Windows]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=494</guid>
		<description><![CDATA[I was installing Exchange 2010 on a new Windows Server 2008 R2 virtual machine, but could not get past the installer&#8217;s system checks, receiving the follow error message: [server.mydomain.local] Connecting to remote server failed with the following error message : The client cannot connect to the destination specified in the request. Verify that the service [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>I was installing Exchange 2010 on a new Windows Server 2008 R2 virtual machine, but could not get past the installer&#8217;s system checks, receiving the follow error message:</p>
<blockquote><p>[server.mydomain.local] Connecting to remote server failed with the following error message : The client cannot connect to the destination specified in the request. Verify that the service on the destination is running and is accepting requests. Consult the logs and documentation for the WS-Management service running on the destination, most commonly IIS or WinRM. If the destination is the WinRM service, run the following command on the destination to analyze and configure the WinRM service: &#8220;winrm quickconfig&#8221;. For more information, see the about_Remote_Troubleshooting Help topic.<br />
+ CategoryInfo          : OpenError: (System.Manageme&#8230;.RemoteRunspace:RemoteRunspace) [], PSRemotingTransportException<br />
+ FullyQualifiedErrorId : PSSessionOpenFailed</p></blockquote>
<p>The error message itself has almost nothing to do with the actual cause of the problem. After a lot of Googling I found a <a title="TechNet Forums" href="http://social.technet.microsoft.com/Forums/en-US/exchange2010/thread/5af966b5-de5d-4e03-bb20-bb6c8a49255b" target="_blank">post on the TechNet forums</a> from someone who had the same error message, albeit caused by a different problem.</p>
<p>Eventually I figured out that the Server Manager feature installer wizard hadn&#8217;t installed the full selection of <strong>.NET 3.5.1 Features</strong>. After installing the entire sub-tree, the Exchange 2010 installation proceeded without any further problems.</p>
<p>Microsoft have now been kind enough to add automatic feature installation to the installer for Exchange Server 2010 SP1, which should help alleviate this kind of problem in future <img src="http://www.fr3d.org/wordpress/wp-includes/images/smilies/simple-smile.png" alt=":)" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow: hidden;">Server Manager -&gt; Features -&gt; &#8220;.NET 3.5.1 Features&#8221;</div>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/08/exchange-2010-installation-management-shell-error/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Results Day</title>
		<link>http://www.fr3d.org/2010/07/results-day/</link>
		<comments>http://www.fr3d.org/2010/07/results-day/#comments</comments>
		<pubDate>Fri, 16 Jul 2010 14:19:40 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[Uni]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=395</guid>
		<description><![CDATA[I just got back from collecting my results from Uni 😀 Bachelor of Science with Honours in Computer Science (Network Communications) First Class And my dissertation was an &#8216;A&#8217; grade 😀]]></description>
				<content:encoded><![CDATA[<p>I just got back from collecting my results from Uni <img src="http://s.w.org/images/core/emoji/72x72/1f600.png" alt="😀" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p>
<blockquote><p><em>Bachelor of Science with Honours in Computer Science (Network Communications) <strong>First Class</strong></em></p></blockquote>
<p>And my dissertation was an &#8216;A&#8217; grade <img src="http://s.w.org/images/core/emoji/72x72/1f600.png" alt="😀" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/07/results-day/feed/</wfw:commentRss>
		<slash:comments>1</slash:comments>
		</item>
		<item>
		<title>ActionFTP 1.1.0.0</title>
		<link>http://www.fr3d.org/2010/06/actionftp-1100/</link>
		<comments>http://www.fr3d.org/2010/06/actionftp-1100/#comments</comments>
		<pubDate>Mon, 28 Jun 2010 18:25:03 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[ActionFTP]]></category>
		<category><![CDATA[Software]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=291</guid>
		<description><![CDATA[I have released a new version of ActionFTP – my free add-in for WindowClippings. Some big new features: HTTP uploads: you can now chose to upload images to imgdash, localhostr or upload3r URL shortening: you can chose to automatically shorten links using is.gd, twurl.nl or cli.gs Code copying: Can now chose to copy HTML &#60;img&#62;, [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>I have released a new version of <a title="ActionFTP" href="/actionftp/">ActionFTP</a> – my free add-in for <a title="WindowClippings" href="http://www.windowclippings.com/" target="_blank">WindowClippings</a>.</p>
<p>Some big new features:</p>
<ul>
<li><strong>HTTP uploads</strong>: you can now chose to upload images to imgdash, localhostr or upload3r</li>
<li><strong>URL shortening</strong>: you can chose to automatically shorten links using is.gd, twurl.nl or cli.gs</li>
<li><strong>Code copying</strong>: Can now chose to copy HTML &lt;img&gt;, HTML hyperlink (&lt;a&gt;), BBcode [img] or BBcode [url] tags to the clipboard, instead of just the direct link</li>
</ul>
<p>Naturally there are lots of other smaller changes and bug fixes as well; see the <a title="ActionFTP" href="/actionftp/">ActionFTP</a> page for the download link and the entire list of changes.</p>
<p><strong>Upgrade Note</strong>: You need to copy two additional files (included in the download) to the WindowClippings directory (Newtonsoft.Json.dll and Newtonsoft.Json.xml).</p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/06/actionftp-1100/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>How-to: Free Upgrades from Adobe CS4 to CS5</title>
		<link>http://www.fr3d.org/2010/06/howto-free-adobe-cs4-to-cs5-upgrades/</link>
		<comments>http://www.fr3d.org/2010/06/howto-free-adobe-cs4-to-cs5-upgrades/#comments</comments>
		<pubDate>Wed, 02 Jun 2010 17:26:54 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[Adobe]]></category>
		<category><![CDATA[Discount]]></category>
		<category><![CDATA[Software]]></category>
		<category><![CDATA[Upgrade]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=261</guid>
		<description><![CDATA[Adobe offer free &#8220;Post Announce Upgrades&#8221; to anyone purchasing a CS4-edition product – including Student editions – after April 12th 2010 and before July 11th 2010. As many CS4 products are currently still available from most retailers, this could be your opportunity to save a bit of money on the full CS5 price – I [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>Adobe offer free &#8220;Post Announce Upgrades&#8221; to anyone purchasing a CS4-edition product – including Student editions – after April 12th 2010 and before July 11th 2010.</p>
<p>As many CS4 products are currently still available from most retailers, this could be your opportunity to save a bit of money on the full CS5 price – I saved about £80 on the full price of Web Premium CS5 (Student edition).</p>
<p><a title="Larger @ Flickr" href="http://www.flickr.com/photos/fr3d/4663257351/" target="_blank"><img class="alignnone" title="Adobe CS4 &amp; CS5 DVDs" src="http://farm5.static.flickr.com/4025/4663257351_dd6c7295d4.jpg" alt="" width="500" height="333" /></a></p>
<p><span id="more-261"></span>After registering your CS4 serial number, visit the <a title="Adobe Customer Support Portal" href="https://www.adobe.com/cfusion/support/index.cfm?event=portal" target="_blank">Adobe Customer Support Portal</a> (Adobe login required) and complete the &#8220;Post Announce Upgrade&#8221; form before July 26th:</p>
<p><img class="alignnone" title="Adobe Customer Service Portal" src="http://www.fr3d.org/ss/lando/Adobe_-_Customer_Support_Portal_-_Mozilla_Hypnoostrich_46315.png" alt="" width="743" height="304" /></p>
<p>Assuming you successfully complete the form, you should receive your CS5 upgrade in the mail after a few days.</p>
<p><strong>Notes:</strong></p>
<ul>
<li>You must purchase your CS4 product before <strong>July 11th</strong>, and complete the PAU request before <strong>July 26th</strong>.</li>
<li><a title="Adobe CS4 upgrade information" href="http://www.amazon.co.uk/gp/feature.html/ref=amb_link_156871827_1?ie=UTF8&amp;docId=1000390913" target="_blank">This handy page</a> on Amazon UK lays out further information and T&amp;Cs, though the offer is not limited to purchases from Amazon.</li>
</ul>
<div id="_mcePaste" style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow: hidden;">https://www.adobe.com/cfusion/support/index.cfm?event=portal</div>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/06/howto-free-adobe-cs4-to-cs5-upgrades/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>Busy Busy Busy</title>
		<link>http://www.fr3d.org/2010/04/busy-busy-busy/</link>
		<comments>http://www.fr3d.org/2010/04/busy-busy-busy/#comments</comments>
		<pubDate>Tue, 27 Apr 2010 23:30:38 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[Blog]]></category>
		<category><![CDATA[Uni]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=254</guid>
		<description><![CDATA[Just a quick post to say that I haven&#8217;t forgotten about my blog, I&#8217;m just really busy finishing up my Final Year Project/Dissertation]]></description>
				<content:encoded><![CDATA[<p>Just a quick post to say that I haven&#8217;t forgotten about my blog, I&#8217;m just really busy finishing up my Final Year Project/Dissertation <img src="http://www.fr3d.org/wordpress/wp-includes/images/smilies/simple-smile.png" alt=":)" class="wp-smiley" style="height: 1em; max-height: 1em;" /></p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/04/busy-busy-busy/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
		<item>
		<title>MySQL Full-Text Searching</title>
		<link>http://www.fr3d.org/2010/03/mysql-full-text-searching/</link>
		<comments>http://www.fr3d.org/2010/03/mysql-full-text-searching/#comments</comments>
		<pubDate>Sat, 27 Mar 2010 22:31:37 +0000</pubDate>
		<dc:creator><![CDATA[Fr3d]]></dc:creator>
				<category><![CDATA[Everything]]></category>
		<category><![CDATA[MySQL]]></category>
		<category><![CDATA[PHP]]></category>
		<category><![CDATA[Search]]></category>

		<guid isPermaLink="false">http://www.fr3d.org/?p=219</guid>
		<description><![CDATA[Most people* immediately think of the &#8216;LIKE&#8217; operator when they want to do a quick search in SQL. If you only want to search for a single keyword in a small table, then there is (arguably) nothing wrong with this. However, when you start wanting to search for multiple terms, search for certain terms while [&#8230;]]]></description>
				<content:encoded><![CDATA[<p>Most people* immediately think of the  &#8216;LIKE&#8217; operator when they want  to do a quick search in SQL. If you only want to search for a  single keyword in a small table, then there is (arguably) nothing wrong  with this.</p>
<p>However, when you start wanting to search for multiple terms,  search for certain terms while excluding others, or searching large  tables, &#8216;LIKE&#8217; will get slow and very inaccurate.</p>
<p>One major cause of this inaccuracy is that the  search terms are looked for in the order they are specified. For example, the  following query would match &#8220;We use PHP and MySQL to power this  website.&#8221;, but would not match &#8220;We use MySQL and PHP to power this  website.&#8221;:</p>

<div class="wp_syntax"><table><tr><td class="code"><pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">*</span> <span style="color: #993333; font-weight: bold;">FROM</span> articles <span style="color: #993333; font-weight: bold;">WHERE</span> body <span style="color: #993333; font-weight: bold;">LIKE</span> <span style="color: #ff0000;">'%php%mysql%'</span> <span style="color: #993333; font-weight: bold;">AND</span> body <span style="color: #993333; font-weight: bold;">NOT</span> <span style="color: #993333; font-weight: bold;">LIKE</span> <span style="color: #ff0000;">'%wordpress%'</span>;</pre></td></tr></table></div>

<p>After discovering the above limitation first-hand (while implementing a search box on my <a title="QuoteDB" href="/quotes/" target="_blank">QuoteDB</a> system), I came an alternative: Full-Text matching.</p>
<p><a title="Using MySQL Full-text Searching - Zend DevZone" href="http://http://devzone.zend.com/article/1304" target="_blank">This article</a> on MySQL Full-Text Searching on the Zend DevZone was particularly helpful on this topic, so I recommend you give it a read. For those too lazy to read the entire thing, Full-Text matching requires a single step before you can use it: you must first add a  &#8216;FULLTEXT&#8217; index to the field(s) you wish search:</p>

<div class="wp_syntax"><table><tr><td class="code"><pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">ALTER</span> <span style="color: #993333; font-weight: bold;">TABLE</span> articles <span style="color: #993333; font-weight: bold;">ADD</span> FULLTEXT<span style="color: #66cc66;">&#40;</span>body<span style="color: #66cc66;">&#41;</span>;</pre></td></tr></table></div>

<p>Once that&#8217;s done, you can perform very fast and accurate searches, including (since MySQL 4.0.1) boolean mode operators to dramatically increase the search power. (For an idea of the power of boolean mode, have a look at <a title="MySQL Full-Text Search Boolean Mode Operators" href="http://devzone.zend.com/article/1304#Heading14" target="_blank">the operators table</a>.)</p>

<div class="wp_syntax"><table><tr><td class="code"><pre class="sql" style="font-family:monospace;"><span style="color: #993333; font-weight: bold;">SELECT</span> <span style="color: #66cc66;">*,</span> <span style="color: #993333; font-weight: bold;">MATCH</span><span style="color: #66cc66;">&#40;</span>body<span style="color: #66cc66;">&#41;</span> AGAINST <span style="color: #66cc66;">&#40;</span><span style="color: #ff0000;">'+php +mysql -wordpress'</span> <span style="color: #993333; font-weight: bold;">IN</span> <span style="color: #993333; font-weight: bold;">BOOLEAN</span> MODE<span style="color: #66cc66;">&#41;</span> <span style="color: #993333; font-weight: bold;">AS</span> score <span style="color: #993333; font-weight: bold;">FROM</span> articles
<span style="color: #993333; font-weight: bold;">WHERE</span> <span style="color: #993333; font-weight: bold;">MATCH</span><span style="color: #66cc66;">&#40;</span>body<span style="color: #66cc66;">&#41;</span> AGAINST <span style="color: #66cc66;">&#40;</span><span style="color: #ff0000;">'+php +mysql -wordpress'</span> <span style="color: #993333; font-weight: bold;">IN</span> <span style="color: #993333; font-weight: bold;">BOOLEAN</span> MODE<span style="color: #66cc66;">&#41;</span>;</pre></td></tr></table></div>

<p>Unlike the &#8216;LIKE&#8217; search, thanks to Full-Text matching, this query would match both of the &#8220;We use&#8230;&#8221; text strings.</p>
<p><small>* </small><small>This included myself, </small><small>until I discovered Full-Text matching.</small></p>
]]></content:encoded>
			<wfw:commentRss>http://www.fr3d.org/2010/03/mysql-full-text-searching/feed/</wfw:commentRss>
		<slash:comments>0</slash:comments>
		</item>
	</channel>
</rss>
