![]() Not only will it will make your SQL table larger, but it will also slow down certain operations like column additions, subtractions and additional indexing. ![]() Now you don’t necessarily need to follow the recommendations as they are based solely on existing data, but it may help put you on the right track and get you thinkingįor a dataset as large as this it’s infinitely important to create proper indexes on your data based off of what you need to do with the data on the front-end, BUT if you plan to manipulate the data beforehand refrain from placing too many indexes on the data. The result will be a description of each columns information along with a recommendation for what type of datatype it should be along with a proper length. You can do this by executing the following SQL command: ANALYZE TABLE my_big_table As an additional step after you are done with your database, you make want to see what MySQL suggests as field types for all of your different fields. You want to accommodate for the right amounts of data and try to avoid varchar columns and overly large data types when the data doesn’t warrant it. Take your time when it comes to planning out the different fields and analyze the data to figure out what the best field types, defaults and field length. MySQL AnalyzeYour databases design/structure is going to be a large factor in how it performs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |