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 if we try to compare 100 records versus 100,000 records with one table and the same fields. Obviously the 100 records will querry much faster than the 100,000. Then I realize no wonder my program frequently generate connection timeout as I initialize the computation of bills.

Then I began to wonder if microsoft vision is to make a software with bulit-in everything don't you think became more buggy? Who cares right I bet microsoft already thought about that before I do right? and besides they hire the most intelligent creature that they can find.

As for me I'll be charging my way through this records and align the system as fast as I can. Christmas in a cubicle is a hell no!

Comments

Post a Comment

Popular posts from this blog

Apple's Edge Over Microsoft?

In the world of IT, models created by business empires will dictate the future of their products. Microsoft is using the component model as the key to win customers and Apple is using the end-to-end model. Microsoft Windows platform crushed Apple's Macintosh platform the day Microsoft release Windows 98 and pirates come out in the open and dominate every stall in our local mall and computer shops. iPod maybe the best and coolest mp3 player that I have ever seen but I still don't think that Apple will dominate the cell phone era for this place belongs to Asia particularly Nokia and Sony Ericson. I don't know why Walter Mossberg thinks US company will always dominate the world when in fact there is another company that belongs to the world and its called Open Source. I think he is dead wrong with his perception. Without a doubt nobody comes close to iPod in the field of mp3 player however, with the release of Sony Ericson latest cell phone such as W900i. An intelligent human ...
Read more

High Grounds Cafe - Best Internet Cafe in the Philippines

Image
I was looking for a nice place to chill last Monday to unwind my thoughts and enjoy with my family. I heard about the latest Internet Cafe just open 3 months ago and I decided to check it out. I have seen a lot of Internet Cafe but nothing comes close to this shop. Everything was simply high end from its ambiance, food and computers. It was simply the best place for people who want to collaborate and enjoy together.
Read more

GWT+MySQL Best Practice

Image
Migrating from GWT-EXT to native GWT has never been an easy task as I expect it would. I took me some moths to really absorb the fundamentals of its Java code, structure and pattern. The price for taking this challenge was undoubtedly more gratifying especially on performance and size. I had lesser reboot due to memory leak and I had better handling on syntax especially on database due to its strict use of its object. Here are some improvements on my code: DatabaseServiceImpl.java String url = "jdbc:mysql://localhost:3306/"; String db = "mydb"; String driver = "com.mysql.jdbc.Driver"; String user = "myuser"; String password = "mypassword"; public String connectDatabase() { String resultString; try{ Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url+db, user, password); //conn = DriverManager.getConnection...
Read more