Results 1 to 38 of 38
-
21-11-2007, 02:04 PM #1
Scrubing the data base to improve speed!
Perhaps the site should consider a system that delets all users who have only 1 post total after a month as with all users with no posts after the same timming?
This I think would greatly improve the speed and efficiency of the data base!
-
21-11-2007, 04:30 PM #2
Re: Scrubing the data base to improve speed!
Thats abit harsh MG (is that an acronym for Mean G**)
What is a few seconds wait compared to the potential of forging new meaningful relationships with similar people to ourselves and ........... oh I see why
Go for it then, scrub them. Let thier data be stricken from the annals of our beloved forum.
-
21-11-2007, 10:03 PM #3
Re: Scrubing the data base to improve speed!
Weren't you having trouble with poor internet speeds before MG ?
Brian - Newton Abbot, Devon, UK
Retired March 2015
-
22-11-2007, 12:39 AM #4
Re: Scrubing the data base to improve speed!
MG Poney
I agree with speeding things up but not to delete posts. Surely there must be a faster way - this site is painfully slow. Iv'e got a crappy slow connection but it works faster on all other sites. Is there something we can do with our internet/antivirus settings to improve speed?
-
22-11-2007, 11:06 PM #5
Re: Scrubing the data base to improve speed!
I think members that haven't been online for a certain time or have only posted once or twice should be deleted to free up space as Mg says. There are so many people that find this website ask a question and then we never hear of them again. If the worse comes to the worse though and they want to post something again then surely they can just sign up again?
The difference between genius and stupidity is that genius has its limits.
Marc
-
22-11-2007, 11:50 PM #6
Re: Scrubing the data base to improve speed!
Too many spammers doing nothing but saying "Send me all your data to this email." and never returning and such why waste time with such useles things?
if all they are going to do is post once and never return why waste the space? Several forums I know of do this and it greatly reduces load on the DB server and over all improves the servers respons time.
Nothing to do with my internet connection two differant towns three differant providers, several differant computers and all the same odd error with it taking forever.
-
22-11-2007, 11:52 PM #7
Re: Scrubing the data base to improve speed!
-
23-11-2007, 12:29 AM #8
Re: Scrubing the data base to improve speed!
OK, I'll jump in again.
I have also had the odd slowdown and have put it down to dear old Microsoft and the performance of Internet Explorer.
So I changed over to Mozilla Firefox and the speed increase has been quite amazing and not just on this site.
So I would like to suggest that you try it, it's a 5.5mb download, and post your comments regarding it's performance please.Brian - Newton Abbot, Devon, UK
Retired March 2015
-
23-11-2007, 03:03 PM #9
-
23-11-2007, 06:40 PM #10
Re: Scrubing the data base to improve speed!
I dont have any problem on here ever with slow speeds though ever. I am on a fast connection and i too use firefox. Have come across it a few times though, were the page wont load due to servers being busy.
The difference between genius and stupidity is that genius has its limits.
Marc
-
23-11-2007, 07:19 PM #11
Re: Scrubing the data base to improve speed!
It is getting really bad sometimes taking 3/4 mins and countless refresh clicks.
Maybe MG has got a point. Perhaps the site could do with a little pruning, although maybe not quite as severe as MG suggests.
-
24-11-2007, 04:00 AM #12
-
24-11-2007, 01:49 PM #13
Re: Scrubing the data base to improve speed!
Pruning the posts, threads or members will not enhance the speed of the forum. It would only ever increase the speed of the 'search' function.
There may however be a problem with the adverts or something on the site, although I have never experienced any problems with the speed.
I think Webram is looking into it.
ChillinIF AT FIRST YOU DON`T SUCCEED.
DESTROY ALL EVIDENCE THAT YOU TRIED!
and go get a cuppa
-
24-11-2007, 03:06 PM #14
Re: Scrubing the data base to improve speed!
Hi, The MG Pony
Sorry about your problems, but I am much far away from RE server and without any problems so far...seems your problem is maybe in some conflicts within your systems and maybe site....or with your ISP throttling complete traffic....slow and old equipment etc...
Best regards, Josip
It's impossible to make anything foolproof because fools are so ingenious...
Don't ever underestimate the power of stupid people when they are in large groups.
Please, don't teach me how to be stupid....
No job is as important as to jeopardize the safety of you or those that you work with.
-
24-11-2007, 04:28 PM #15
- Join Date
- Jan 2001
- Location
- Fife, Scotland.
- Age
- 65
- Posts
- 1,199
- Blog Entries
- 2
- Rep Power
- 20
Re: Scrubing the data base to improve speed!
also use firefox instead of ie, its far better
-
25-11-2007, 01:02 AM #16
Re: Scrubing the data base to improve speed!
I hardly ever have probs with speed, Ive got broadband
-
26-11-2007, 03:03 AM #17
Re: Scrubing the data base to improve speed!
If that where true other sites would have the same problem, but they do not it is ONLY this site, a Dual 3.2GHz Xeon server with 4MBit connection that has 2 gigs ram on a 3Com 3900 series switch has the same issue as any other PC I vissit this site on so certainly not old cuomputer or under powered
-
26-11-2007, 01:40 PM #18
Re: Scrubing the data base to improve speed!
Hi, The MG Pony
True, it is not old and not weak, maybe to switch to Mozilla....hope Dez will find out something...I'm not an expert for this, just trying to help...
BTW...last night I faced some problems...
I was logged and reading unread posts, but looking again for unread posts (click on link) I was logged out automatically....that last for couple of minutes (need to log in few times, open RE in another tab...later on no problem....
Best regards, Josip
It's impossible to make anything foolproof because fools are so ingenious...
Don't ever underestimate the power of stupid people when they are in large groups.
Please, don't teach me how to be stupid....
No job is as important as to jeopardize the safety of you or those that you work with.
-
26-11-2007, 03:55 PM #19
Re: Scrubing the data base to improve speed!
I've come on under knoppix a totaly differant O/S and explorer.
It is some thing internal to this one site, I've never seen it on any other!
And I still think scrubing the data base by time Vs total post count system would work well.
Not pruning posts but pruning the one shot wonders by erasing the waste of space accounts they create to never use!
-
27-11-2007, 11:49 AM #20
Re: Scrubing the data base to improve speed!
Mate its your PCs relationship to this site, don't know how or why coz Im not a computer guy but all i know is this, I have 512k connection (nothing flash there), am in Australia (which has a very poor broadband service) and am using Firefox on a IBM lenovo T60 laptop (also nothing flash there) and i have no issues what so ever. When I say no issues i mean page loads instantly, no 3/4 minute wait. I know what you mean though, i use a forum that is SLOW at its server end, this IS NOT ONE OF THEM, I guarantee it or I'd see it too.
Is it your firewall or anti spam programs that are doing this?...and she said "give it to me you big fridgie"
-
27-11-2007, 03:22 PM #21
Re: Scrubing the data base to improve speed!
The site seems a lot faster today. Is it because we aren't getting the Google ad's inbetween posts now Dez?
-
27-11-2007, 03:29 PM #22
Re: Scrubing the data base to improve speed!
Oh for christ sake how many times do I need to repeat my bloody self!
FACT: FIVE or so DIFFERANT COMPUTERS IN TWO DIFFERANT CITIES SAME PROBLEM
I am, as we speek, in Surrey, BC, using a friends PC and same sh*t as my server at home!
But this is about geting rid of two year old accounts with the users only post being "Please send me your data"
-
27-11-2007, 08:52 PM #23
Re: Scrubing the data base to improve speed!
Deleting these accounts will NOT make the forum any faster.
Deleting posts/threads will also NOT make this site any faster.
The only thing that would actually make this site faster is that if there were less members active at any one time. And even this would not really be noticeable.
I believe its the adverts here that might be making it slow for certain users.
If you are sitting behind a firewall that doesn't like a particular site/ http address or link then that will be the problem, because the link from that site will take long and then it might even change itself.
It also could be your area, ISP provider, browser, OS, internet settings or just about anything else.
I personally never had a problem with the speed of this site, but there do seem to be a number of people that are having a problem. I think Webram is still looking into it.
ChillinIF AT FIRST YOU DON`T SUCCEED.
DESTROY ALL EVIDENCE THAT YOU TRIED!
and go get a cuppa
-
28-11-2007, 11:41 AM #24
Re: Scrubing the data base to improve speed!
sorry mate what was that I didn't catch you, can you please repeat yourself...
you are right, let the whole thing change and erase everyones posts just coz you can't work out your issue...
its not the server or i would see it too, try your ISP first.
Never had an issue in 6 years....and she said "give it to me you big fridgie"
-
28-11-2007, 04:13 PM #25
Re: Scrubing the data base to improve speed!
You still don't quite grasp the point do you 750?
It improves reliability as well that was the main point, I hate wasted space, and thats all thoughs people are that make just 1 post and it isn't even one worth keeping, "send all me you data to *email addy*"
***Edited by Frank**
But again this is not the point of why I started this thread, it was the fact we have a ton of garbage posts and wasted database area on 1 shot wonders that never return just going "gimme you data to me email!"
Geting rid of that trash, greatly improves the query function, increases reliability and will speed up browsing as every time you change a thread a BD opperation happens to refresh the list, don't forget what a web site like this is, a giant database, any thing that can be don to keep it free of junk as possible improves every thing! Especialy security and reliability!!!
I think your message has been heard load and clear MG. Lets leave it now and see what Webram comes up with. FrankLast edited by frank; 28-11-2007 at 05:24 PM.
-
29-11-2007, 10:58 AM #26
Re: Scrubing the data base to improve speed!
Well maybe you should push to be a moderator then you can erase as you see fit
I do grasp your point... I think its you who cannot see the other side of the coin - not everyone has these issues so it is not necessarily the server and as others have said deleting posts will not necessarily speed up what you see at your end.
Why don't you start be deleting your 964 posts and see if that helps to speed things up a bit
Of all the computers you try are you using the same ISP...
I just don't think the whole database should be censored because you have issues, these one hit wonders as you describe it may contain info.
Ironically this thread is taking up your precious bandwidthLast edited by 750 Valve; 29-11-2007 at 11:01 AM.
...and she said "give it to me you big fridgie"
-
29-11-2007, 03:41 PM #27
Re: Scrubing the data base to improve speed!
It is not just the posts it is the deat accounts both aut to be removed, it is the removal of the inactive non contributing accounts that take the toll
There are three majour ISP
Rogers
Shaw
CCNet (DeltaCable)
So it may be a server seting that does not play well with a country tag but lets ignor my problem lets look at the benifits to the server
It improves reliability
It reduces wasted space
It improves DB Speed (Used allot more then some seem to think)
Generaly good things happen
THIS thread is nothing to do with my issue, I have no idea how it ended up like this but who cares still get rid of wasted DB space and is not censoring, it is called maintanance, if there useles post of "Gimme" with no feed back is so important to them they'll easily create a new account and spam again.Last edited by The MG Pony; 29-11-2007 at 03:45 PM.
-
01-12-2007, 02:39 AM #28
Re: Scrubing the data base to improve speed!
Brian,
I took you up on your recommendation to download Firefox. Man, Oh man is that a difference.
It's literally like going from dial-up to DSL!
I can now really enjoy my cable modem.
Good call on that one, thanks guys!If all else fails, ask for help.
-
01-12-2007, 02:54 AM #29
Re: Scrubing the data base to improve speed!
Hi, Mike
Now you can go to Tools>Add-ons and check there which of them you can use...some of them are quite nice and helpful...adblock plus....fire FTP...FlashGot....forecastfox...NoScript....PDFdownload...Skype extension for firefox...and many other...link is here..
https://addons.mozilla.org/en-US/firefox/browse/type:1
Best regards, Josip
It's impossible to make anything foolproof because fools are so ingenious...
Don't ever underestimate the power of stupid people when they are in large groups.
Please, don't teach me how to be stupid....
No job is as important as to jeopardize the safety of you or those that you work with.
-
01-12-2007, 07:57 AM #30
Re: Scrubing the data base to improve speed!
Thanks Josip.
I will look into these add-ons and see which ones I will get. The dictionary and spelling would be the most helpful for me.If all else fails, ask for help.
-
01-12-2007, 11:51 AM #31
Re: Scrubing the data base to improve speed!
yep firefox rocks
...and she said "give it to me you big fridgie"
-
01-12-2007, 12:12 PM #32
Re: Scrubing the data base to improve speed!
Cant aggree more, Just downloaded firefox and my internet speed had gone through the roof
Thanks Brian, tried to give you a rep point for that one but being told i have got to spread it around !!!
Regards
RaymondLast edited by Latte; 01-12-2007 at 12:15 PM.
-
02-12-2007, 01:05 AM #33
Re: Scrubing the data base to improve speed!
Glad to hear about the improvement for one and all.
Yep the spell checker is the best add-on without doubt. A red underline with a correction via a right-click - simple, done it twice in this post already !!Brian - Newton Abbot, Devon, UK
Retired March 2015
-
02-12-2007, 01:51 AM #34
Re: Scrubing the data base to improve speed!
You guys were still using Internet Explorer?
I never thought to mention it, just assumed my estemed colleagues were in the modern age. It has problems with a few web sites but is perfered by almost all I know.
Just to be sure, you have heard of Ball Point Pens, Zippers, Frozen Foods, Twist Off Caps, and Microwave Ovens haven't you?
-
02-12-2007, 01:55 AM #35
-
10-12-2007, 01:23 AM #36
- Join Date
- Sep 2007
- Location
- Split Croatia
- Age
- 57
- Posts
- 6,175
- Blog Entries
- 6
- Rep Power
- 36
Re: Scrubing the data base to improve speed!
To Firefox's users!
NoScript is great ad-on and greatly improve speed, because forbids scripts to bee executed without your consent. Most of scripts are adds and you choose which of them you allow to execute.
-
10-12-2007, 01:45 AM #37
Re: Scrubing the data base to improve speed!
Well done Nike123, a very useful addon, thanks.
Brian - Newton Abbot, Devon, UK
Retired March 2015
-
10-12-2007, 09:57 AM #38
- Join Date
- Sep 2007
- Location
- Split Croatia
- Age
- 57
- Posts
- 6,175
- Blog Entries
- 6
- Rep Power
- 36
Similar Threads
-
Data Base
By Samarjit Sen in forum Do you have a suggestion for the RE Forums?Replies: 1Last Post: 29-09-2006, 06:13 PM