<div>
<div class="content wysiwyg-content">
I have a csv file with 4000 rows and just 4 columns of data.<br />
Right now I have it sitting in a mysql database, and I search through it and return search results through ajax onto my web page.<br />
Would it be faster to convert my csv to json?
</div>
</div>


I have a csv file with 4000 rows and just 4 columns of data.
Right now I have it sitting in a mysql database, and I search through it and return search results through ajax onto my web page.
Would it be faster to convert my csv to json?

json file vs sql database

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.

JavaScript

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Asynchronous JavaScript and XML (AJAX) is a group of interrelated Web development techniques used on the client-side to create asynchronous Web applications. With AJAX, web applications can send data to and retrieve from a server asynchronously (in the background) without interfering with the display and behavior of the existing page. HTML and CSS can be used in combination to mark up and style information. The Document Object Model (DOM) is accessed with JavaScript to dynamically display and allow interaction with the information presented.