Z-Car

Ramblings about everything from Cars to Computers

Z-Car
  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

MySQL – Should you put an index on a Boolean field to help query performance?

By Prodromus June 14, 2010 MySQL, Query Optimization 2 Comments
MySQL – Should you put an index on a Boolean field to help query performance?

I am often asked if it makes sense to place an index on a Boolean field in order to improve query performance.  In general, because a boolean value can only…

Read more

MySQL – DateTime vs. TimeStamp – When to use?

By Prodromus June 12, 2010 MySQL, Optimization No Comments
MySQL – DateTime vs. TimeStamp – When to use?

This question often comes up, and while there is often a heated debate, these are my thoughts on the subject. I typically use a timestamp when I need to record…

Read more

MySQL – Constraints on Hierarchical Data in a Self-Referential Table

By Prodromus June 1, 2010 MySQL No Comments
MySQL –  Constraints on Hierarchical Data in a Self-Referential Table

I recently had a client who was using a table structure that utilized a self-referential structure using an ID field and Parent_ID fields. After upgrading to Innodb, his DBA was…

Read more

MySQL Foreign Key Night-mare

By Prodromus March 26, 2010 MySQL 1 Comment
MySQL Foreign Key Night-mare

I recently was working with a 3rd party DB that was designed well and used lots of foreign keys to enforce referential integrity. Unfortunately, the application that used the DB…

Read more

  • About the House of ZAbout the House of Z
  • McDonnell Douglas F-4 Phantom II
  • Steve Bounds 1966 Porsche 911Steve Bounds 1966 Porsche 911

Recent Posts

  • 2005 Laser Blue Lotus Elise for Sale
  • 2011 MacBook Pro GPU Failure – A software fix to disable GPU
  • Unable to renew using LetsEncrypt Certbot-Auto with CRON – Fail
  • Installing LetsEncrypt Certbot on Amazon Linux Server
  • Upgrade your Miata’s headlights with Hella H4 halogen bulbs, Cibie eCode projectors, and a relay kit.

Pages

  • 1993 Mazda RX-7 CYM
  • 1997 Mazda Miata
  • A Day at Summit Point – 5/17/1997
  • Datsun 240Z show in PA – 5/25/1998
  • Frederick Air Show – 8/18/2003
  • Gary’s House of Z
  • LilyPon’s British Car Day June 1,2008
  • Lockheed F-117 Nighthawk
  • Mazda RX-7 crash at Summit Point
  • Mikoyan-Gurevich MiG-17
  • Northrop Grumman B-2 Spirit
  • R/C Flying 2008
  • Rockwell B-1 Lancer
  • Rockwell International Space Shuttle
  • Steven F. Udvar-Hazy Center – National Air and Space Museum
  • Sukhoi PAK FA T-50
  • Westminster Airshow 2008

Copyright © 2022 Z-Car | Theme by: Theme Horse | Powered by: WordPress