FAQ FAQ   Search Search   Memberlist Memberlist   Usergroups Usergroups   Register Register 
PhpBB- & WordPress- antispam.com
Home of the Antispam for all fields mod ! 
  Profile Profile   Log in to check your private messages Log in to check your private messages  Log inLog in 

 PhpBB- & WordPress- antispam.com Forum Index » [PhpBB2] Submit a bug » Spam Database - takes a LONG time
  The time now is Wed May 23, 2018 7:28 pm 

 Post new topic   Reply to topic View previous topic :: View next topic  
Author Message
PostPosted: Sat Jul 28, 2007 6:40 pm    Post subject: Spam Database - takes a LONG time  Reply with quote  

WebSnail
Phpbb coder


Joined: 14 Dec 2006
Posts: 38

Which antispam version?
1.2.7 (same with 1.2.6 / 1.2.5)

Which phpbb version?
2.0.22

Can you describe the bug?
When the database has more than a few records in it it takes an absolute age to load up... This seems to be down to a LOT of SQL requests being made so I'd suggest cacheing or reducing the load requirement.

What happened before the bug was visible/triggered ?
Never known it to be any better.

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Sun Jul 29, 2007 10:28 pm    Post subject:  Reply with quote  

Lord Raiden
Experienced user


Joined: 11 Dec 2006
Posts: 123

I don't have any issues with the database taking a long time to load up. Are you referring to when a user is posting, or when you're checking the database? If it's the spam database that has all the trapped spam items, it loads fine for me.

TOP View user's profileSend private message  BOTTOM
PostPosted: Tue Jul 31, 2007 10:46 am    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

Backend coding of the SQL bit is not as optimal as the front end.
But I'll give it a go in the next releases.

This could also depend on your machine as you may know Wink
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
PostPosted: Fri Oct 19, 2007 8:55 pm    Post subject:  Reply with quote  

ramon fincken
Site Admin


Joined: 11 Dec 2006
Posts: 269
Location: A'dam/Diemen, The Netherlands

I've added a 'semi cache' using an array like:

[0]
123.123.123.123
> status > banned

[1]
124.124.124.124
> status > looking_clean


etc..

this will reduce any new lookups for allready retrieved IP's in the backend ( spam database )
_________________
Phpbbantispam founder, available for freelance WordPress coding.

PhpBB2 mod: http://www.phpbbantispam.com/viewtopic.php?t=1
WordPress plugin: http://wordpress.org/extend/plugins/antispam-for-all-fields/
Project files & mailinglist: https://sourceforge.net/projects/phpbbantispam/

TOP View user's profileSend private messageVisit poster's website  BOTTOM
 Post new topic   Reply to topic All times are GMT + 1 Hour

Display posts from previous:   
 PhpBB- & WordPress- antispam.com Forum Index » [PhpBB2] Submit a bug » Spam Database - takes a LONG time
 
 Page 1 of 1
 
 
 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Jump to:  


     Powered by phpBB © 2001, 2005 phpBB Group | Template Neon | Snelle Managed WordPress webhosting