![]() As you can see everything else loads blazingly fast except for the initial load. There are screenshots of Chrome's network tab below that show the timing difference. With that logic even on my computer it got stuck for about 4-5 seconds and then it suddenly loaded the content. I tried separating the query in as little JOINs as possible and then execute multiple simple queries to add the additional information to my information array, but then I got a different problem. I do have a GeForce 1070M in it, but I don't think that affects mysql performance. Now, I'm no expert, but my computer is not 120 times faster than the server and it also runs a bunch of other processes. The other sections load blazingly fast, except for the one that uses a lot of joins. I thought that it probably needed some boosting so I temporarily upgraded it to have 2VCPUs and 2 GB of RAM, but it made no difference. The production server was originally a basic DO instance with 1GB of RAM and 1 VCPU. My laptop has the following specs: Intel Core i7-6700 HQ, 16 GB of DDR4 RAM and the server is running on a 5400 RPM HDD, it's not even on my SSD drive, that's only where the MySQL engine is. Now I am no expert, but my computer is not 120 times faster than the production server on DigitalOcean. On my production server which is a virtual machine on DigitalOcean it takes about 5 minutes! to load the exact same content with the exact same query. With Good Wi-Fi it takes about 1.3 seconds to load. The thing is that in this case on my local computer the specific section that uses those queries takes about 2.5 seconds to load with network throttling enabled as Regular wi-fi. I had experience of a site slowing and I had to optimize some queries. ![]() So, the issue here is this, I have several queries that use a lot of JOINs and some of the tables have a couple of thousand entries while some of the others have about 200-300 thousand entries. ![]() I am building a site that uses a lot of database queries, so I was kind of afraid this might happen. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |