🚀 go-pugleaf

I do not know about IB7.xx performance, but IB6.x is not comparable with
MSSQL.
It is not only string indexes. Also joint queries and something like WHERE
ID IN (<list>)
where <list> is thousands of items long. MSSQL handles this with ease.
Maybe I should look at IB7 but company would not buy it. We use IB for the
purpose
of distributing our catalogs as free sql server. We cannot distribute
licensed version.
MSSQL is widely accepted server our customers depend on. We cannot just tell
them "hey, you need to buy Interbase cause we like it more and do not like
microsoft".

Again - I do not know how IB7 looks but we need very usable SQL manager, at
least like
in MSSQL (which is way far from being ideal itself). IB6 has scarce
management console, period.

Regards.


"Craig Stuntz [TeamB]" <cstuntz@nospamplease.com (but use vertexsoftware to
email)> wrote in message
news:MPG.18480ee333660d0e98a225@newsgroups.borland.com...
> In article <3ddd565d$1@newsgroups.borland.com>, nkarasev@e-dn.com says...
> > However, in this case MSSQL is a lot more stable and what's more
important
> > alot faster than Interbase.
> >
> You need to understand how IB's indices work.
>
> IB string indices work from the beginning of the string forward.
> They're not useful for locating substrings in the middle of a string
> field.  So if you're searching for a substring at the beginning of a
> string field, you need to make sure that IB knows this.  You can use
> STARTING WITH instead of like (no wildcards in STARTING WITH), or you can
> use LIKE with a constant expresssion and no wildcard at the beginning.  If
> you use LIKE with a parameter, however, IB doesn't know whether you're
> looking for a constant, a substring with a wildcard at the end, or a
> substring with a wildcard at the beginning, so the optimizer won't be able
> to specify the use of the index.
>
> *When an index is used* IB should be comparable to SQL Server on
> similar hardware in this case.  If SQL Server is using an index and IB is
> not, then of course SQL Server will be faster.
>
> -Craig
>
> --
> Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
> Delphi/InterBase Weblog : http://delphi.weblogs.com
> InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
> InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer