Database Changes
After encountering a problem with creating a Wall-2-Wall function just like Facebook allows I encountered problems with quering the comments from the database because of how I separated the tables of comments. To solve this I have just regrouped all the comment tables into one larger table. With this change it’ll decrease the amount of code in some modules thus making a slight speed improvement.
Looking at it all it seemed pointless with the current size of the site and the realistic size of it in the future to separate the comment tables in such a manner. If in the future something needs to be done then MySQL partitioning should be available for me to use when taht change is needed. Until then the current method should work fine for a few million comments, maybe even the 10’s of millions depending on the database server I have.
As this change is quite major there are a lot of things which have now been broken, so they are being fixed as they are found.
Current Lines of Code: 22,000+ (approx)
Current Version: 3.0.8a (Alpha)