Slicing the database to pieces
Just this morning was the usual busy day for me as I try to demonstrate the system over and over again. One module that caught my attention was the consumption history of the user. It is a list of their electricity consumption. As I demonstrate my program one thing that caught my attention was the speed of foxpro to display the results. Faster than my super power sql server. Then I begin to wonder couldn't it be that the hundred thousand microsoft sql server was out perform by a free foxpro database files? Its ridiculous! impossible! Then I begin to realize that the structure of my database was indeed a big mistake. I over load the power of sql server by making it one chuck of table where records from district 1 to 17 are all rolled to one table. It may seem nice since worrying about maintenance was quite a piece of cake but then when I began to start the slicing and uploading some records a lot of ideas suddenly comes into my mind. I realize that indeed it will be faster. Imagine ...