Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
But one of the first steps you should take on is to split this 10+ columns into separate tables, so you can make faster query responses for a greater variety of queries.
Another idea is to cluster your stored information into separate databases for different years of data item creation or ranges of customer lastnames.
So you can ignore millions of datasets for a query when they are irrelevant. -
@TylerDDevRant interesting. Splitting the data would require a conditional based query with from different servers though right?
-
@TylerDDevRant i've talked with the lead dev, we could do it, but we are fully using php and relational databases right now. This would require a new stack, learning it, testing and i would be probably working in it alone, because the other devs would be working on other parts of the project
Related Rants
Oh sh*t
Best eays to improve database performance?
I have a huge database table with a lot of data, 10+columns and around 5-6million rows and growing. We are thinking about optimisation methods, the data will be frequently accessed, but not in the same ways. even though caching is helping, some initial requests take 6-20secs. What are good ways to improve a relational db performance? The data is date and item based, every item can have some data back from 2016 or older and up to 1000 related rows in each day. Every day new data would be added. Right now working with php.
question
mysql
databases
optimisation
database
php