Speeding up browsing
Folks, another system announcement for the backend changes we have implemented today:
If you browse on tradebit through categories with a lot of files (like Hard Rock), the loading time of pages at the end of the list was getting higher and higher. I have invested some time to clean up some SQL statements for the browsing requests and was able to lower the load time significantly!
This is a very specific but necessary step and worth a little blog post for the database admins out there:
If you do a
select * from productstable limit PAGE,AMOUNT
it seems that MySQL could take VERY long to retrieve the data - our page load time at the end of bigger categories was almost 30 seconds. Much too long to convert nicely!
Now we changed the code to pick the highest primary key and select the data with a modification like:
select * from productstable where primarykey>=lowestkey limit AMOUNT
and voilá: speed increased by factor 1000!
You might want to take a look at the speed of loading the HARD ROCK category on a high page and look how fast it is now for yourself. Remember: it took 20-30 seconds to load that page!
