![\"\"](\"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2-150x150.png?resize=150%2C150\" "\\"the-spot.net")
After spending some time thinking about different ways to re-enable the RSS feature for the-spot.net, I’ve finally hit on an idea that I’ve started writing the code for.<\/p>\nAfter spending some time thinking about different ways to re-enable the RSS feature for the-spot.net, I’ve finally hit on an idea that I’ve started writing the code for.<\/p>\n
The original code would hit the main database to grab the newest posts on the forums…after it sorted all 77000 posts by date, and then grabbed the top 15-20 of them and their data. Since the entire site runs off of that one database, you can imagine how that would slow down everything when even just 10 people hit the site every 15 minutes.<\/p>\n
So I am going to attempt my first distributed database scenario. With this new code, when you make a post, it stores it to the main database as well as some of the data to a second database on another server I have. This setup will send only the relevant data for producing the RSS feed, and when the RSS page executes, it will run on that data.<\/p>\n
I’ll give more technical details about this code in another post for those that are interested. This is just to let everyone know that there is something being worked on for the site, even though you don’t see a whole lot being done up front.<\/p>\n","protected":false},"excerpt":{"rendered":"
After spending some time thinking about different ways to re-enable the RSS feature for the-spot.net, I’ve finally hit on an idea that I’ve started writing the code for. The original code would hit the main database to grab the newest posts on the forums…after it sorted all 77000 posts by date, and then grabbed the […]<\/p>\n","protected":false},"author":1,"featured_media":1181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11,9],"tags":[214,211,50,212,208,51,154,213,209,52,215],"class_list":["post-90","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-projects","category-the-spot-net","tag-code","tag-database-server","tag-distributed-database","tag-feed","tag-post","tag-relevant-data","tag-rss","tag-setup","tag-site","tag-technical-details","tag-time"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1","jetpack_likes_enabled":false,"jetpack_shortlink":"https:\/\/wp.me\/prOO4-1s","jetpack-related-posts":[{"id":91,"url":"https:\/\/thepizzy.net\/blog\/2007\/05\/update-new-rss-code-in-the-works\/","url_meta":{"origin":90,"position":0},"title":"Update: New RSS Code in the works.","author":"[[Neo]]","date":"May 28, 2007","format":false,"excerpt":"Earlier I posted on the RSS Code that I'm working on. I've done quite a bit of work on it so far - learning about the various functions that PHP offers. Most of what I thought I was learning while setting up the forums was not actually PHP's functions, they\u2026","rel":"","context":"In "Programming"","block_context":{"text":"Programming","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/programming\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":63,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-movement\/","url_meta":{"origin":90,"position":1},"title":"Update: tsnX Database Movement","author":"[[Neo]]","date":"June 9, 2006","format":false,"excerpt":"I'm backing up the tsnX.3 Beta's Database (with the posts, forums, and accounts) and going to start moving the tsnV database into the tsnX site. The site is going to be down for a bit, while I do this, and iron out the kinks of auth-access, and conversions. If things\u2026","rel":"","context":"In "Projects"","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":100,"url":"https:\/\/thepizzy.net\/blog\/2008\/01\/twitter-tsn7\/","url_meta":{"origin":90,"position":2},"title":"twitter & tsn.7","author":"[[Neo]]","date":"January 30, 2008","format":false,"excerpt":"With a new My Spot page comes new possibilities. This time around, I'm going to make a concerted effort to actually write in new code and attach a new database backend that pulls from the phpbb database and the users' accounts on the-spot.net.With this new plan, there will be increased\u2026","rel":"","context":"In "Programming"","block_context":{"text":"Programming","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/programming\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":33,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-profile-cp-999\/","url_meta":{"origin":90,"position":3},"title":"Update: tsnX – Profile CP @ 99.9%","author":"[[Neo]]","date":"April 9, 2006","format":false,"excerpt":"I just finished editing the code for the profile control panel. I only have to test it now, but I can't do that until I get a response and resolution to the domain name issues. For some reason \"the-spot.net\" does not work, but the other domains that I have on\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":44,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/n3-winkydonetblog-tsnx\/","url_meta":{"origin":90,"position":4},"title":"N3: winkydo.net\/blog, tsnX, Spotcasting","author":"[[Neo]]","date":"April 21, 2006","format":false,"excerpt":"Tonight, we work on winkydo.net\/blog and \/teck...continue working on tsnX's new features and code modifications, preparing it for graphic redesign, and Spotcasting with video. Nerd Night @ Neo's is brought to you by Google Adsense (click the ads, plz - help pay for this crap), and by Beef Jerky (get\u2026","rel":"","context":"In "Projects"","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":62,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-conversion-50\/","url_meta":{"origin":90,"position":5},"title":"Update: tsnX Database Conversion @ 50%","author":"[[Neo]]","date":"June 6, 2006","format":false,"excerpt":"Ok, so I'm converting the tsnV database into one that will work with the tsnX database structure. What this will do is bring our posts, user accounts, and forums over from the old site and make it work with the mods and settings of the new site. It's something I\u2026","rel":"","context":"In "Projects"","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/comments?post=90"}],"version-history":[{"count":4,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/90\/revisions"}],"predecessor-version":[{"id":1194,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/90\/revisions\/1194"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media\/1181"}],"wp:attachment":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media?parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/categories?post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/tags?post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}