[Help] I am in a great mood this morning/tonight! Updates to this post /post/227931-i-am-in-a-great-mood-this-morningt Tue, 24 Nov 2009 00:44:41 +0100 Reply from PureLogix /post/227931-i-am-in-a-great-mood-this-morningt#reply-4606496 A guy could use the site for a few years and even with amalgamated tables each table would still be pretty small in size.

]]> PureLogix Tue, 16 Dec 2008 15:02:52 +0100 Reply from PureLogix /post/227931-i-am-in-a-great-mood-this-morningt#reply-4606492 Not quite. There are several independent catagories that you may not nececarily have information for but the way the database is designed each user gets their own tables that contain the potential to record information in all of the catagories. It simplifies the whole ordeal… I think having 6 to 100+ tables per user is just crazy and multiplies the work.

Some may have info while others don’t and some may have none at all. Its all good now though.

]]> PureLogix Tue, 16 Dec 2008 15:01:05 +0100 Reply from chunkymove /post/227931-i-am-in-a-great-mood-this-morningt#reply-4606480 and you were trying to display it graphically along side months taht had data for every day?

]]> chunkymove Tue, 16 Dec 2008 14:57:17 +0100 Reply from PureLogix /post/227931-i-am-in-a-great-mood-this-morningt#reply-4606477 yeah, but it the number of values being solved were always differnt.

Like if there was data for the 15th of the month but there was not another entry until the 20th and then the next time was on the 30th.

It figures out the missing information by creating virtual data that is non-existent. So you have to deal with variable temporal gaps plus a whole bunch of other things that make it difficult. Its quirky stuff.

]]> PureLogix Tue, 16 Dec 2008 14:55:46 +0100 Reply from chunkymove /post/227931-i-am-in-a-great-mood-this-morningt#reply-4606463 as douglas adams said “grab a towel”.

when you say interpolate, do you mean average from the values either side?

]]> chunkymove Tue, 16 Dec 2008 14:51:01 +0100