How to get Fast MyISAM table loads.

December 4th, 2008

Tokuview (http://blogs.tokutek.com/tokuview/iibench/) is building a test scripts/program for 1B record insert performance. 

This is fine, but ultimately the logistics of the DB environment will dictate what ‘tricks’ can be pulled to insert records the fastest.  Can you access raw MyISAM files or not?  Are you running concurrent inserts?  Do you require ACID compliance?

There are 3 basic techniques I’ve found for inserting records into a MyISAM DB table are:

Read the rest of this entry »

Interesting Games

May 7th, 2008

For my friends, I’ve found a small treasure trove of free games (some) are of very high-quality & well tested.

     http://en.wikipedia.org/wiki/List_of_open_source_games

Most of the the games on this site are remakes of original games that you had to buy.  If you don’t mind an occasional obscure bug during game-play you’ll probly find something you can enjoy.  Another great thing about these games is that they were created under the concept of ‘Open Source’ where a group software writer created these games out of personal interest. 

FreeCiv has been my bane for the last several weeks, sucking up all my free time.   It took me ~600 turns to ‘win’ the space race.  Now I can resume a normal life.
My basic tricks for improving game play:

  • Economy vs Happiness… Simply keep this balanced, and attempt to get to a Democracy government A.S.A.P.  The Democracy allows for the largest army when you have the JS Bach wonder & Cure for Cancer wonder.
  • Building large cities is best by choosing the sequence of improvements:
    (This is a highlights list) granary, market place, aquaduct, supermarket, mass transit, super highways, recycling center.  Sprinkle in between these items manufacturing improvements.�
    Another big action is ‘Transform’ the terrain around your city to 75% Grasslands with infrastructure of Farms.  This will allow for the largest cities of size 27+.
  • War machine: Use a barrage of airplanes to remove all the city’s defending units.  If there is a SAM present, use a spy to disable it first.  Protect the spy with an entourage mechanized infantry.

I’m also looking forward to a production release of Free Orion.  This is a remake of Master of Orion, that is in development.  I played the game in its alpha stages, a limited tech tree and the war-machine was non-existant,  however the look-n-feel is great.  The graphics were beautiful & the management of the planets was easy, allowing for more of a macro-mangement approach.  I hope they provide a better reports feature in future versions.

I’ve also got a small download section of my personal favorite games here, if you are interested.

Happy Gaming,
– JJ –

Next Generation Input Device - Wii Controllers

February 5th, 2008

After seeing the Blog from Johnny Lee (specifically this video) and the recent demo from Jim Foley using the Wii controller in a Flash web page, I truely believe that Nintendo didn’t realize they are going to be selling more controllers without selling the console system.

The Wii remote provides 6 axies of input:
Motion: (X) forward/backward, (Y)side-to-side, (Z) up/down
Angles: Pitch, Yaw, Rotation

Compare this to a mouse:
(X)  forward/backward, and (Y)side-to-side.

The high end joysticks are able to provide 6 axies of input, but not with such simplicity:
Tilt = (X)forward/backwards, (Y)side-to-side, and no (Z) up/down.
Twist=angle of rotation,
Rudder=2nd rotation/velocity input
Top-Hat=Viewing direction (Forward,Backwards,Left,Right).

The Wiimote software is DirectX and Java inputs friendly, so I’m gonna try to join in on this fun with my own 3D demo, eventually.

Thanks to Nintendo for a new controller!

– JJ –

Additional Links:
http://www.biggestpixel.com – Real-time 3D in a Flash Player.
http://www2.tokai.or.jp/N_EDGE/md2/md2_test.swf – Real-time 3D in a Flash Player
http://www.wiiflash.org – Resource for Wii and Flash Player integration.

Laptop disection

February 4th, 2008

I got the joy of disecting a laptop this weekend.  A friend has been having issues with the audio not working out of the built-in speakers, unless a headphone was connected.  The normal usage of headphones is to disable the built-in speakers which caused this to be a curious project.

Read the rest of this entry »

Artifical Intelligence (Pandora’s box?)

February 2nd, 2008

First I’d like to say that Artificial Intelligence is dangerous.  I don’t think humanity will be able to control its own creations.  Humanity has a conscience (ability to distinguish between right/wrong), while our creations could not. 

With that said, here is my idea on how to create Pandora’s Box (from a Java Programmer’s point of view).

Read the rest of this entry »