ComeAndGetThem
New member
Seems like Calguns is down again..
.
.
Tired of Calguns older Marketplace that can't upload pictures or do feedback ratings?
Try our Search function! Listing am item is easy and easy for people to find things.Register a free account today to become a member! Once signed in, you'll be able to participate and use features that aren't available to guests!The new Calguns feels "blazingly fast" compared to the old site.
How do you search in market place ?The new Calguns feels "blazingly fast" compared to the old site.
What this says to me is there are some bad queries people are hitting.. There's too much garbage data. If they wanted to clean it up, they would have to do a slow query analysis and start finding the hot spots and nuking them directly in the DBYeah, clearly some slow spots - VB folks will need to analyze usage and set up more resources, I think.
I keep getting 500 errors when posting. It's extremely slow to look at a forum and then try to get back to the display of forum links. Have to use browser refresh.What this says to me is there are some bad queries people are hitting.. There's too much garbage data. If they wanted to clean it up, they would have to do a slow query analysis and start finding the hot spots and nuking them directly in the DB
Yeah.. query gets built and sent and mysql throws an error. The DB must be thrashing right now. If they did this last year it would've worked. That jump to the incompatible database is likely the root cause IMHO. They need a DBA to sanitize it, i'm not sure if CG is going to be able to recover. I'm also not sure if vBulletin is going to try to clean up the data, 55gb is a lot.I keep getting 500 errors when posting. It's extremely slow to look at a forum and then try to get back to the display of forum links. Have to use browser refresh.
Yeah, its looking better... They probably are nuking those queries, its looking more consistent..It's a whole bunch better after two hours of smacking things around.
Mod stuff works; not currently getting 500s; pages display faster and consistently.
Somebody is paying attention out there ...
And, so far as I am aware, that won't be a feature there. I could be surprised.Yes, CalGuns is back up, but it's slow. Trying the marketplace, there doesn't seem to be a way to filter for a specific brand of gun.
Ha ha ha. I tried CZ and it said too many entries. So I added SP-01 and it said no entries found.And, so far as I am aware, that won't be a feature there. I could be surprised.
At the very top there is a search box.
I tried 'glock' and it returned only 4 threads, one back to 2022, plus 2 wrong retrievals. Indexing not complete? I dunno.
Yeah it takes time. The vb team looks like their handling business so that's the best news for today.I’ll give them a week to get things sorted out.
That post made me snicker. I'm quite sure for a forum (where everything is text based, and the DB is generic open-source software), 55 GB is a lot. But having worked with database people (I used to go to lunch with the people who designed the very first relational database), 55 GB doesn't even rate. Even 10 or 15 years ago, at the VLDB conference (the acronym stands for "very large database", people were talking about Terabytes. Today, we can query petabyte-sized databases interactively and online. But those are databases with very structured data, not long text fields.... They need a DBA to sanitize it,... 55gb is a lot.
The off-topic forums. Man oh man oh man. I bet if we just deleted all the "tere hanges" and "TDS" posts, it would be much easier.Those "bump" posts man ...
What does this even mean?"tere hanges"
Depends on the DB for MySql it’s a lot cause it’s single threaded.at the VLDB conference (the acronym stands for "very large database", people were talking about Terabytes.
What does this even mean?