Sunday 8 January 2017

Using a JSON file as a database returns data faster then a dedicated Mysql server?

an example data block from the JSON file.{ "Name": "testing", "Private": "yes", "Project_Index": "index\r\nproject.json\r\nextras", "Readme": "", "Contributors": "everyone", "Creator": "myself", "Language": "", "Version": "all the versions", "UsernameDB": "", "PasswordDB": "", "Comment": "", "UserCommented": "", "TimeStamp": "0000-00-00", "Project_comments": . } There are a few hundred blocks like that, of varying sizes, the code requires it like a module, then loops through it until it finds a match then returns the block that contains the match. Its nearly twice as fast as MySQL, with the same data, I exported the JSON data directly from Phpmyadmin so the data is exactly the same. Is mysql just slow or does JSON just better for my purpose? Any input appreciated, I am kinda confused on this. Thank you.

Submitted January 08, 2017 at 06:08PM by OzziePeck

No comments:

Post a Comment