cbKeyMost when indexing needs additional overhead

I recently helped someone track down why they were getting JET_errKeyTruncated. They declared an index over a JET_coltypLongBinary column with cbMax = 0x20c, and when they created the index, they specified cbKeyMost = 0x20c, and also passed in VistaGrbits.IndexDisallowTruncation (they were using ManagedEsent). But then they were getting JET_errKeyTruncated when setting a value with length…

0

ManagedEsent is in Windows 8.1 and on MSDN.

I’m super excited to share this: ManagedEsent is documented on MSDN: http://msdn.microsoft.com/en-us/library/windows/desktop/dn375980.aspx And it’s part of Windows 8.1. No need to download from CodePlex! Here’s what’s on my 8.1 machine: C:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Ic1a2041b#\3862e50725b3d2f5ef48c19f24b17ef3\Microsoft.Isam.Esent.Interop.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_32\Microsoft.Ic1a2041b#\3862e50725b3d2f5ef48c19f24b17ef3\Microsoft.Isam.Esent.Interop.ni.dll.auxC:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ic1a2041b#\85216777bd911aef15b30bda8b0046b8\Microsoft.Isam.Esent.Interop.ni.dllC:\Windows\assembly\NativeImages_v4.0.30319_64\Microsoft.Ic1a2041b#\85216777bd911aef15b30bda8b0046b8\Microsoft.Isam.Esent.Interop.ni.dll.auxC:\Windows\Microsoft.NET\assembly\GAC_MSIL\microsoft.isam.esent.interop\v4.0_6.3.0.0__31bf3856ad364e35\Microsoft.Isam.Esent.Interop.dllC:\Windows\WinSxS\msil_microsoft.isam.esent.interop_31bf3856ad364e35_6.3.9600.16384_none_b4cbc5488cc56490\Microsoft.Isam.Esent.Interop.dll   Enjoy! -martin

5

Cost of JetIntersectIndexes

We recently had a question about JetIntersectIndexes()’s performance. Here’s what Brett wrote up:   Intersect is to save disk IO at the cost of CPU time. The cost of intersect indices, is the cost of iterating over ALL the index ranges (choice #3 below).  That may not sound like a savings, HOWEVER index entries are…

0