Dennis' Domino Blog

Category: "SNTT"

Removing a full text index on a server

  07/13/09 11:42 am, by , Categories: SNTT, Lotus, Development
I've whipped up this little code after searching the web on how to use the C-api.
It's actually easier then I thought, but I'm sharing it anyway.

'Remove FTI: Declare Function FTDeleteIndex Lib "nnotes.dll" (Byval hDB As Long) As Integer Declare Function NSFDbClose Lib "nnotes.dll" (Byval hDB As Long) As Integer Declare Function NSFDbOpen Lib "nnotes.dll" (Byval filepath As String, DB As Long) As Integer Declare Function OSPathNetConstruct Lib "NNOTES" Alias "OSPathNetConstruct" _ ( Byval NullPort As Long, Byval Server As String, Byval FIle As String, _ Byval PathNet As String) As Integer Sub Initialize Dim Bufferstr As String Dim ReturnCodel As Long Dim hDB As Long Dim errorstr As String Dim pathName As String pathName = String(256, " ") Call OSPathNetConstruct(0, SERVER, PATH, pathName) Dim result As Integer 'open the dataase result = NSFDbOpen(pathName, hDb) If Result <> 0 Then errorstr="An error occurred in the main routine calling the API function NSFDbOpen." & Chr$(10) & "The return code was " & Trim$(Str$(ReturnCodel)) & "." Exit Sub End If 'Delete the index ReturnCodel = FTDeleteIndex(hDB) If ReturnCodel <> 0 Then errorstr="An error occurred in the main routine calling the API function FTDeleteIndex." & Chr$(10) & "The return code was " & Trim$(Str$(ReturnCodel)) & "." Call NSFDbClose(hDB) Exit Sub End If 'Close the database ReturnCodel = NSFDbClose(hDB) End Sub
ls2html was brought to you by nsftools.com

Download the code here: removefti.lss
5 comments »

[SNTT] Notes 8 Design and Data compression

  02/29/08 08:56 am, by , Categories: SNTT, Lotus
Ok, so it's a friday, but I'll go ahead with the tag anyway.

Today I conducted a little test on my 8.0.1 testserver to see what the gain would be if I enabled data and/or design compression.

See the table below:

CompressionSizeGain/Loss %
My Mailbox before any changes 657.664 Mb 0,00
My Mailbox after R8 design (ODS43) 666.112 Mb 1,28 %
My Mailbox after R8 ODS (ODS48) 664.064 Mb 0,97 %
My Mailbox after R8 Design Compression (ODS48) 650.240 Mb -1,13 %
My Mailbox after R8 Data Compression (ODS48) 492.032 Mb -25,18 %
My Mailbox after R8 ODS+ D&D compression(ODS48) 478.208 Mb -27,29 %


Quite interesting results!

It requires some further testing with smaller and bigger mailboxes, but if I average at 20%, I'd be really happy!

Usefull tools.

  02/22/08 01:38 pm, by , Categories: SNTT, IBM, Lotus
I'd like to share some "tools" I use on a day to day basis as a Notes Admin



Of course this is not a full list, but it's a start.

What tools do you use on a day to day basis?

Alan Lepofsky has a huge resource with tools
 

©2017 by Dennis van Remortel

Contact | Help | b2evolution skin by Asevo | blog software | hosts