Re: [firebird-support] Firebird and Windows 2011 Server - slow?

2012-09-30 Thread Alexey Kovyazin
There is no such thing as Windows Server 2011. Yes there is: Windows Small Business Server 2011: Oh! Regards, Alexey [Non-text portions of this message have been removed]

Re: [firebird-support] When does OIT = OAT?

2012-09-30 Thread Dmitry Kuzmenko
Hello, ruan_h! Sunday, September 30, 2012, 8:09:27 AM, you wrote: r Oldest transaction 1 r Oldest active 2 r Oldest snapshot 2 r Next transaction3 this is the most normal transaction state. OIT+1 = OST = OAT = Next -1 r What does OIT = 1 mean here? r I then

Re: [firebird-support] Advice on indexes when searching containing

2012-09-30 Thread Mark Rotteveel
On 29-9-2012 19:51, Newbie wrote: Is there a way to use indexes in searching for partial string in a field? for example table book has field Title. and is needed to search also partially matching Title. I made an index on title and noticed, when searching where title = 'keyword'; the index