Search found 8 matches

Hi,

This is the other query I can't get to use an index and it is only using where:

SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<='1276259140' AND `ip_hi`>='1276259140') A ...

Just make sure no other query is using, sorting or calling data from that field. If you use the print out query method I mention in the PM you can check easily all the queries that use that table on a ...

Wow, now I am confuse Shocked

.

I was not thinking of confusion, just in presentation.

Hi Raven,

What I was trying to say was that the email client is displaying the code & instead of just & for the ampersand.

Thank you,

Hi,

I just got this notification email:

http://www.ravenphpscripts.com/modules.php?name=Private_Messages&file=index&folder=inbox

Can you see what is wrong about it?

If yo ...

Hi Raven,

I saw the three index of the initial installation:

index 1 (ip_lo, ip_hi)
index 2 (c2c)
index 3 (date)

but if you notice on the table the "cardinality" of each index is not equal ...

Hi,

I found that the query:

SELECT `c2c` FROM `nuke_nsnst_ip2country` WHERE `ip_lo`<='3702851360' AND `ip_hi`>='3702851360' LIMIT 0,1

Was showing up as a query that was not using index ...

Hi,

Just a quick note.

One the file /includes/nukesentinel.php on line 375 there is a little bug that can cause this PHP Warning:

PHP Warning: stristr() [<a href='function ...

Author	Message
Topic: Small DB optimization
emilacosta Replies: 9 Views: 14624	Forum: NukeSentinel(tm) v2.6.x Posted: Sun Jul 26, 2009 11:30 pm Subject: re: Small DB optimization
emilacosta Replies: 9 Views: 14624	Hi, This is the other query I can't get to use an index and it is only using where: SELECT * FROM `nuke_nsnst_ip2country` WHERE (`ip_lo`<='1276259140' AND `ip_hi`>='1276259140') A ...
Topic: Small DB optimization
emilacosta Replies: 9 Views: 14624	Forum: NukeSentinel(tm) v2.6.x Posted: Sun Jul 26, 2009 10:52 pm Subject: re: Small DB optimization
emilacosta Replies: 9 Views: 14624	Just make sure no other query is using, sorting or calling data from that field. If you use the print out query method I mention in the PM you can check easily all the queries that use that table on a ...
Topic: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Forum: BB2Nuke Posted: Sat Jul 25, 2009 11:57 am Subject: re: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Wow, now I am confuse . I was not thinking of confusion, just in presentation.
Topic: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Forum: BB2Nuke Posted: Sat Jul 25, 2009 11:38 am Subject: re: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Hi Raven, What I was trying to say was that the email client is displaying the code & instead of just & for the ampersand. Thank you,
Topic: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Forum: BB2Nuke Posted: Sat Jul 25, 2009 10:11 am Subject: Notifications Emails Little Bug
emilacosta Replies: 5 Views: 9990	Hi, I just got this notification email: http://www.ravenphpscripts.com/modules.php?name=Private_Messages&file=index&folder=inbox Can you see what is wrong about it? If yo ...
Topic: Small DB optimization
emilacosta Replies: 9 Views: 14624	Forum: NukeSentinel(tm) v2.6.x Posted: Thu May 14, 2009 10:54 pm Subject: re: Small DB optimization
emilacosta Replies: 9 Views: 14624	Hi Raven, I saw the three index of the initial installation: index 1 (ip_lo, ip_hi) index 2 (c2c) index 3 (date) but if you notice on the table the "cardinality" of each index is not equal ...
Topic: Small DB optimization
emilacosta Replies: 9 Views: 14624	Forum: NukeSentinel(tm) v2.6.x Posted: Thu May 14, 2009 7:49 pm Subject: Small DB optimization
emilacosta Replies: 9 Views: 14624	Hi, I found that the query: SELECT `c2c` FROM `nuke_nsnst_ip2country` WHERE `ip_lo`<='3702851360' AND `ip_hi`>='3702851360' LIMIT 0,1 Was showing up as a query that was not using index ...
Topic: NS 2.6 (at least) little bug
emilacosta Replies: 1 Views: 6434	Forum: NukeSentinel(tm) v2.6.x Posted: Tue Apr 07, 2009 10:06 pm Subject: NS 2.6 (at least) little bug
emilacosta Replies: 1 Views: 6434	Hi, Just a quick note. One the file /includes/nukesentinel.php on line 375 there is a little bug that can cause this PHP Warning: PHP Warning: stristr() [<a href='function ...