| View previous topic :: View next topic |
| Author |
Message |
CPUShack
Joined: 16 Jun 2003
Posts: 34258
Location: State of Jefferson, USA
|
 Posted: Thu Apr 09, 2020 3:35 pm Post subject: |
 |
|
| Mixeur wrote: | | Yes sometimes. Due to sql request overloads. Mainly due to a too big bots traffic (3 times real users !). I'm trying to reduce it using htaccess but I half succeeded for the moment... |
ah yah Bots are insanely annoying!
_________________
New for 2025! The CPU Shack has a co-processor!
Visit The CPU Shack of microprocessor history and information. |
|
| Back to top |
|
 |
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
| Posted: Sun Apr 19, 2020 6:32 am Post subject: |
|
|
| Mixeur wrote: | | Yes sometimes. Due to sql request overloads. Mainly due to a too big bots traffic (3 times real users !). I'm trying to reduce it using htaccess but I half succeeded for the moment... |
SQL request overload should be solved now. I was limited to 40000 requests an hour, but after setting up a counter to count the SQL request on my code, I figured out that the menu was using between 254 (main site, x86 Cpus menu opened & 500 (Xhoba's collection menu opened). Ten years ago, I was coding with my feets, and if it was working it was good for me. So I setup many recursives requests which made the SQL queries increase exponentially.
My previous hoster didn't have SQL queries by hour limitations, so it was not really an issue.
Now it is solved, menu is only using between 7 & 14 queries max.
I will continue to optimise some other pages, just in case, but that won't be the priority right now.
Let me know, if you see any other issue.
_________________
Register on x86-guide.net to manage and share your collection on-line !
Need to find a x86 ? Go to http://www.x86-guide.net ! Over 12000 chips listed ! |
|
| Back to top |
|
|
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Sun Apr 19, 2020 6:49 am Post subject: |
|
|
| Mixeur wrote: | | SQL request overload should be solved now. |
Good news and congrats !  Now its working flawlessly.
_________________
Visit ABC CPU - Virtual CPU Museum. |
|
| Back to top |
|
|
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
|
| Back to top |
|
|
xhoba
Joined: 20 Apr 2009
Posts: 4596
Location: Picardie, France
|
|
| Back to top |
|
|
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
|
| Back to top |
|
|
rjluna2
Joined: 27 Oct 2014
Posts: 1302
Location: Hiram, GA, USA
|
|
| Back to top |
|
|
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
|
| Back to top |
|
|
CPUShack
Joined: 16 Jun 2003
Posts: 34258
Location: State of Jefferson, USA
|
| Posted: Fri Sep 04, 2020 12:31 am Post subject: |
|
|
| Mixeur wrote: | With the arrival of a package from Vegeta, I reached 2K (x86) CPUs in my collection yesterday !
Not enough room to store all of them... |
Nice work!
_________________
New for 2025! The CPU Shack has a co-processor!
Visit The CPU Shack of microprocessor history and information. |
|
| Back to top |
|
|
Marcin
Joined: 02 Jan 2005
Posts: 8519
Location: Poland
|
| Posted: Fri Sep 04, 2020 2:29 am Post subject: |
|
|
| Mixeur wrote: | With the arrival of a package from Vegeta, I reached 2K (x86) CPUs in my collection yesterday !
Not enough room to store all of them... |
Congrats to you and that problem is a common one 
_________________
Visit ABC CPU - Virtual CPU Museum. |
|
| Back to top |
|
|
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
| Posted: Fri Sep 04, 2020 3:47 am Post subject: |
|
|
| CPUShack wrote: | | Mixeur wrote: | With the arrival of a package from Vegeta, I reached 2K (x86) CPUs in my collection yesterday !
Not enough room to store all of them... |
Nice work! |
And with the arrival of your package, once sorted, we will quickly reach the 20K CPUs with all collections on the site !
_________________
Register on x86-guide.net to manage and share your collection on-line !
Need to find a x86 ? Go to http://www.x86-guide.net ! Over 12000 chips listed ! |
|
| Back to top |
|
|
Vegeta
Joined: 13 Apr 2013
Posts: 7049
|
| Posted: Fri Sep 04, 2020 3:56 am Post subject: |
|
|
Very nice!
_________________
Wanted: 4 x VT-25-A tubes |
|
| Back to top |
|
|
Mixeur
Joined: 06 Jan 2005
Posts: 4038
Location: Sochaux, France
|
|
| Back to top |
|
|
H3nrik V!
Joined: 15 Apr 2014
Posts: 1246
Location: Denmark
|
| Posted: Fri Dec 18, 2020 2:22 am Post subject: |
|
|
| Mixeur wrote: | After a comment from Henrik V! in the Pentium 4 505/505J/506 thread, I decided to translate in english, with the help of Google Translate, my article about the Intel Pentium 4 :
http://www.x86-guide.net/en/cpu/Intel-Pentium%204.html
Google's translation was not perfect, but really good though, and it saved me a lot of time anyway !
If you find any mistake, or you think I may be forgetting something important, please le me know here. |
Actually, I think the automatic translation in Chrome worked pretty decent, so I am looking forward to reading your great piece of work again! Thanks! |
|
| Back to top |
|
|
H3nrik V!
Joined: 15 Apr 2014
Posts: 1246
Location: Denmark
|
| Posted: Fri Dec 18, 2020 2:25 am Post subject: |
|
|
| Oh, but something is not right? |
|
| Back to top |
|
|
|
![[ Hidden ]](https://cdn.cpu-world.com/forum/templates/CPUWorld/images/lang_english/icon_email.gif "[ Hidden ]"){kind=icon}
