Computer Magic
Software Design Just For You

Archive for the 'Database' Category

Intro to Relational Databases

Monday, December 28th, 2009

A database is just a series of one or more tables. Each table is a separate and distinct entity. What makes a database “relational” is the ability to define relationships between one table and another. In some db systems (mssql), you can actually tell the system that there is a relationship. In others (mysql) you […]

Dynamic data layout with vertical tables

Saturday, April 25th, 2009

Developers today are faced with poorly defined requests and constantly changing requirements. It is not uncommon for a developer to spend countless meetings and design sessions getting the database and object layout just right, only to have the client request just one more field when the first beta application is delivered. That one more field […]

InnoDB Corruption common in MySQL

Thursday, November 6th, 2008

I am now recovering corrupt InnoDB files in MySQL for the 6th time in the last year. Not a good sign considering all the press I have seen about how InnoDB should be default storage engine in MySQL and how superior it is with its added features such as transactions. First let me give a […]

MSSQL 2000 – Merge Replication Errors

Wednesday, November 14th, 2007

The ProblemOn a recent project, merge replication was required. Any one who has seriously tried to use MSSQL Merge replication knows that it can be a total pain. It sounds nice, but in practice it can be a real bear. It gets worse if you have had to break the replication manually for any reason.Replication […]

Slow connections to MySQL Server

Thursday, November 2nd, 2006

I have an app that connects to a MySQL Server on a different box. Only one connection is created and it is held for the duration of the app. The minimal time it takes to connect to the database server is not that important so while it bothered me, the 2-5 seconds it took to […]

Home | My Blog | Products | Edumed | About Us | Portfolio | Services | Location | Contact Us | Embedded Python | College Courses | Quick Scan | Web Spy | EZ Auction | Web Hosting
This page has been viewed 837836 times.

Copyright © 2005 Computer Magic And Software Design
(360) 417-6844
computer magic