OpenSMO now running on MySQL!
Posted: Fri Nov 09, 2012 6:18 pm
by Cube
I finished porting over the OpenSMO code to run on MySQL instead of SQlite.
We are currently trying to stress test it to make sure all the changes are working correctly. After we are happy with it we will migrate all database over to the fancy new MySQL Database.
Now running on the main server and site!
Re: OpenSMO now running on MySQL!
Posted: Sat Nov 10, 2012 5:18 am
by Charlo
Is there a reason why SQLite was chosen in the first place? I've rarely seen it used; MySQL is far and away the most popular DB for open-source stuff.
Re: OpenSMO now running on MySQL!
Posted: Sat Nov 10, 2012 10:18 am
by Izzy
Because it is easier to implement and integrate into c#. The issues we were having didn't make a lot of sense in the first place so it is still kind of strange that it was having problems.
Re: OpenSMO now running on MySQL!
Posted: Sat Nov 10, 2012 2:26 pm
by Cube
Re: OpenSMO now running on MySQL!
Posted: Sat Nov 10, 2012 2:26 pm
by owenviau1
ok kool

Re: OpenSMO now running on MySQL!
Posted: Sun Nov 11, 2012 1:31 pm
by crimsoncarnage
I was wondering whether or not a new version of OpenSMO would be released (1.05) that would change to MySQL.
Re: OpenSMO now running on MySQL!
Posted: Mon Nov 12, 2012 12:48 pm
by Angelo
Sqlite was chosen because indeed it was standalone, and thus much easier to put on any kind of machine. I never thought that a big project like SMO.net would come to exist from it..

I saw a pull request on Github that's apparantly what you're running now. Great, but it has a lot of errors and possible security holes. I recommend you don't run this version until you get the latest.
Re: OpenSMO now running on MySQL!
Posted: Tue Nov 13, 2012 3:01 pm
by Cube
Thanks for the merge, I fixed the security issues, which I blame on being tired

I have a few more updates I have not pushed yet, and right now we are seeing some crazy CPU usage we are trying to debug, I will make a branch of the current codebase if you want to take a look.
Update:
https://github.com/concubidated/OpenSMO/tree/smo.net
Re: OpenSMO now running on MySQL!
Posted: Tue Nov 13, 2012 7:24 pm
by houkouonchi
The CPU usage had to do with some of the webchat code that was copied over from a newer commit. Reveriting this and CPU usage is finally back to normal which means the site/server should *finally* be atleast as stable as sqlite was before it was running into the corruption problems (but likely more stable).
Re: OpenSMO now running on MySQL!
Posted: Wed Nov 14, 2012 3:52 pm
by Angelo
The webchat code? I don't see why that would cause high CPU usage.
fast indexing dataframe
Posted: Fri Jul 03, 2026 2:20 pm
by JosephRef
[img]https://live.staticflickr.com/1881/30887424798_a77bcff62c_o.jpg[/img]
We are pleased to denote a pregnant improvement to our indexing service, in real time SpeedyIndex indexes your golf links faster and Sir Thomas More with efficiency than ever so earlier. Directly the % of indexed golf links within 72 hours testament be higher. The changes are valid for tasks added from September 1st. [url=https://t.me/SpeedyIndexBot?start=206352122]fast indexing backlinks[/url]
[url=https://www.reve-interprete.com/interpretation-des-reves/fast-indexing-for-wordpress-t46787.html]fast indexing for wordpress[/url] [url=https://forum.zweb-apps.xyz/memberlist.php?mode=viewprofile&u=1056]fast indexer links[/url] [url=https://forum.zweb-apps.xyz/index.php]fast indexing aamir iqbal[/url] [url=http://turie.eu/forum/viewforum.php?f=22]speed index wordpress plugin[/url] [url=http://forumparkmusic.munpalsta.net/viewtopic.php?f=2&t=15&p=47#p47]speedy index google docs[/url] d1ddde3
@index_systum77=
how to make indexing faster
Posted: Fri Jul 03, 2026 2:21 pm
by JosephRef
[img]https://seobuddy.com/blog/wp-content/uploads/2022/08/how-long-does-it-take-to-learn-seo-blogcover.png[/img]
Quick connection indexing products and services stand for a paradigm change in how we navigate the world wide web. Unlike conventional internet search engine indexing, which relies on web crawlers to find and index content material after some time, quick link indexing providers use ground breaking methods to expedite the method. These companies leverage Superior algorithms and technologies to index new content Just about instantaneously, guaranteeing that users have usage of the newest info at their fingertips. [url=https://tinyurl.com/IndexSpeed]how to speed up google indexing[/url]
[url=https://www.fantasyboardgames.org/viewtopic.php?f=7&t=193314&p=630567#p630567]nothing to link indexing[/url] [url=http://sega.mannlist.com/memberlist.php?mode=viewprofile&u=9725612]speedyindex google forms[/url] [url=http://ewmen.com/viewtopic.php?p=1694703#p1694703]index makes searching fast explain how[/url] [url=https://forum.zweb-apps.xyz/viewtopic.php?p=166529#p166529]fast indexing tool free[/url] [url=https://forum.zweb-apps.xyz/viewtopic.php?p=166489#p166489]speed index tires[/url] d1ddde3
@index_systum77=
how indexing makes search faster
Posted: Fri Jul 03, 2026 2:24 pm
by JosephRef
[img]https://forumgrad.com/wp-content/uploads/2025/02/Blog_012225_TileImage.png[/img]
In addition to their technological prowess, quickly link indexing products and services also prioritize privacy and protection. With escalating issues around info privateness and on the web protection, consumers can have confidence in that their research queries and searching activity are handled Along with the utmost confidentiality and integrity. By implementing robust encryption protocols, information anonymization strategies, and stringent access controls, rapid connection indexing products and services make sure user information and facts remains safeguarded continually. [url=https://linksbuilding.ru/]fast indexing windows download[/url]
[url=https://forum.zweb-apps.xyz/viewtopic.php?p=166318#p166318]speedy index google docs[/url] [url=https://nauc.info/forums/memberlist.php?mode=viewprofile&u=1930626]speedyindex google sheets[/url] [url=http://ww.w.videogame-reviews.net/memberlist.php?mode=viewprofile&u=434186]fast indexing for wordpress[/url] [url=https://forum.zweb-apps.xyz/memberlist.php?mode=viewprofile&u=1056]fast indexer links[/url] [url=https://forum.zweb-apps.xyz/viewtopic.php?p=166516#p166516]speed index of tyre[/url] d1ddde3
@index_systum77=
fast indexing python
Posted: Fri Jul 03, 2026 2:25 pm
by JosephRef
[img]https://media.istockphoto.com/id/2167436347/photo/seo-search-engine-optimization.jpg?b=1&s=612x612&w=0&k=20&c=DcZXnpEPwkoUo2uh5WaogxwySl8-pNpo15n0040GhUs=[/img]
We are proud of to denote a substantial betterment to our indexing service, like a shot SpeedyIndex indexes your golf links faster and more than expeditiously than always earlier. At once the % of indexed golf links within 72 hours testament be higher. The changes are valid for tasks added from September 1st. [url=https://baoly.ru/speedindex]speedyindex google sheets[/url]
[url=https://forum.zweb-apps.xyz/index.php]fast indexing aamir iqbal[/url] [url=https://forum.zweb-apps.xyz/viewtopic.php?p=166516#p166516]speed index of tyre[/url] [url=https://nauc.info/forums/memberlist.php?mode=viewprofile&u=1930626]speedyindex google sheets[/url] [url=http://xn--iexed-eja832dbar49b214w.mannlist.com/memberlist.php?mode=viewprofile&u=9725115]fast indexing in outlook[/url] [url=https://forum.zweb-apps.xyz/viewtopic.php?p=166306#p166306]fast indexing windows[/url] d1ddde3
@index_systum77=