Geeks-Plug-ins

September 16, 2003 Table types in MySQL: Part 1 - HEAP tables By Ian Gilfillan The MySQL table types We all know accessing data in RAM is a lot quicker than accessing data on disk. So, with this in mind, wouldn't it make sense for MySQL to store as much data as possible in memory? The answer is of course yes, and MySQL can in a number of ways. Query caches, holding indexes in memory, and most extreme of all, holding an entire table in memory. The latter is the topic of this article. Tables in memory are called HEAP tables. The MySQL table types include: * MyISAM tables, the default table type, which employs table locking, making it ideal for high volume select, low volume insert/update environments, such as most websites. * InnoDB tables, which supports transactions and referential integrity * ISAM tables, the old MySQL table type, replaced by MyISAM in most instances now. * BDB, which are also transaction safe. * MERGE tables, a table type for a collection of M

Digg / All News, Videos, & Images Groups on Ma.gnolia

ALGORITHM LINK @ SAYWIT BRAIN TEASERS@ SAYWIT

Link to J.K.G (good link for techies )

Link for Security Freaks

You can lock your XP workstation with two clicks of the mouse. Create a new shortcut on your desktop using a right mouse click, and enter 'rundll32.exe user32.dll,LockWorkStation' in the location field. Give the shortcut a name you like. That's it -- just double click on it and your computer will be locked. And if that's not easy enough, Windows key + L will do the same. Go to the Command Prompt in the Accessories menu from the All Programs start button option, and then type 'systeminfo'. The computer will produce a lot of useful info, including the uptime. If you want to keep these, type 'systeminfo > info.txt'. This creates a file called info.txt you can look at later with Notepad. (Professional Edition only). Find that out by typing 'tasklist', which will also tell you a lot about what's going on in your system. You can at last get rid of tasks on the computer from the command line by using 'taskkill /pid' and the task number,

From solving puzzles to eating the right foods, here's how to keep your grey cells in good shape. While there is no fountain of youth for the brain, there is always the next best thing. There is lots you can do right now to preserve, protect and enhance your gray matter. One hint: If you are already a devotee of a heart-healthy lifestyle, you are already on the right track. What is good for the heart is probably good for your head. And that is a great motivator! Here's food for thought's and memory. Although we are what we eat, our brains also respond to our surroundings and the activities we indulge in. Apart from foods, certain lifestyle habits too can give your brain a boost. Follow this food strategy: Keep unhealthy fats to a minimum. Sticking to a diet involving lots of fresh fruits and vegetables, a minimum of red meat, plenty of fish and the occasional red wine is very important. Brains are made up of about 60 per cent fat, but the fuel they rely on is glucose, a sim