Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
  #16  
Old 15 May 2006, 14:53
Spleasure's Avatar
Spleasure Spleasure is offline
 
Join Date: Jun 2002
Real name: Jorrit Schippers
If the vB team would add the index in an upcoming upgrade that upgrade would become problematic for large boards without the index. It has to be introduced very gently to not upset the customers.
Reply With Quote
  #17  
Old 05 Jun 2006, 05:30
DementedMindz DementedMindz is offline
 
Join Date: Jan 2006
ok question if i was to add this add an index to the IP address in the post table and if i upgrade when 3.6 comes out will there be any changes i need to do... just making sure down the line i dont get no errors thanks...


Originally Posted by Paul M
ALTER TABLE post ADD INDEX ipaddress

also i seen this posted before is pauls the right one or is this one the right one?

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Last edited by DementedMindz : 05 Jun 2006 at 05:32.
Reply With Quote
  #18  
Old 07 Jun 2006, 03:55
cscgal's Avatar
cscgal cscgal is offline
 
Join Date: Aug 2003
Pretty sure it's the second.
Reply With Quote
  #19  
Old 07 Jun 2006, 07:15
Spleasure's Avatar
Spleasure Spleasure is offline
 
Join Date: Jun 2002
Real name: Jorrit Schippers
They work both. Note that you have to take care of adding the prefix if you use one.
Reply With Quote
  #20  
Old 15 Jun 2006, 14:50
BoardTracker's Avatar
BoardTracker BoardTracker is offline
 
Join Date: Dec 2005
If I may give a few highlights on indexes and databases (MySQL specifically a well since most of you use that one)

Indexes as Paul M indicated are not really harmful when not used, and are very useful when they are used (as Kevlar noticed).

However, you should be aware of the downside of an unused index.
1. Indexes take time to create. Not only during altering a table but also whenever a new record is added to the table. So bear that in mind. Although, when adding a simple index like IP row index, the effect of it on insert is usually very mild.
2. Indexes do take space. Some more, some less. If you add more and more indexes, especially if they are not used, they can eventually take more space than the data itself. In some cases this is even the desired situation.
3. Indexes can corrupt. Although tables don't get corrupted on a daily basis (thank god), it can (and sometimes does) happen. The less indexes you have, the better in that respect .

So I would say that if an index is not needed, don't add it. As for whether or not VB should add it.. if there are built-in features that do a cumbersome select on a field in what usually gets to be a big table, an index for the field is most likely needed.

Lastly.. there is not much you can do though with regards to the regular full-text search on the database level. This is because databases were not really designed for FTS (FullText search) indexing. It works, but usually for small boards. When your board gets big, FTS will probably grind your servers down.

In case you have that problem, a mod we developed for board owners can solve that problem, by using BoardTracker's search implemented into the board. You can check out boards.ie or rpg.net for examples which use it.
__________________
BoardTracker Search Mod ~ advanced search engine for your board with no server load! (vb3.5, 3.6 and 3.0)
BoardTracker Tagging Mod ~ add thread tagging, tag search and cool tagclouds! (vb3.5, 3.6 and 3.0)

All our mods allow for single or multi-board and global options for true web2.0 functionality..

Last edited by BoardTracker : 15 Jun 2006 at 14:58.
Reply With Quote
  #21  
Old 21 Jul 2006, 12:37
Bulent Tekcan Bulent Tekcan is offline
 
Join Date: Oct 2003
How long time create a index ?
Reply With Quote
  #22  
Old 21 Jul 2006, 13:30
BoardTracker's Avatar
BoardTracker BoardTracker is offline
 
Join Date: Dec 2005
Originally Posted by Bulent Tekcan
How long time create a index ?
It depends how big is the table and what Index type it is.
for non FTS index, it is usually not too long. Only if you have a VERY big table with tens of millions of records, it may take more than a minute. Huge tables, might take more, maybe 5 or even 10 minutes. But I mean HUGE tables.

P.S.
Did you submit your board to Boardtracker for inclusion?
__________________
BoardTracker Search Mod ~ advanced search engine for your board with no server load! (vb3.5, 3.6 and 3.0)
BoardTracker Tagging Mod ~ add thread tagging, tag search and cool tagclouds! (vb3.5, 3.6 and 3.0)

All our mods allow for single or multi-board and global options for true web2.0 functionality..
Reply With Quote
  #23  
Old 22 Jul 2006, 10:07
Bulent Tekcan Bulent Tekcan is offline
 
Join Date: Oct 2003
Himmmm OK

Our post is 2.300.000 And finished 7 minutes my dual opteron machines ,also now very fast search IP adress and without any problem.

Normaly our boards use a big-boards.com,but manytimes they are not updates our data,for example alexa rating.But I'll invest'gation your service

Thanks

Last edited by Bulent Tekcan : 22 Jul 2006 at 10:16.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 23:44.

Layout Options | Width: Wide Color: