🚀 go-pugleaf

In article <3dde661e@newsgroups.borland.com>, nkarasev@e-dn.com says...
> 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.

	In this case, put the <list> in a table and JOIN it in.  Most of 
this is covered in the Help for IB PLANalyzer.

	If you concentrate on the particular things SQL Server is faster at, 
SQL Server will win.  If you concentrate on the things IB is faster at 
(UPDATEs with heavy concurrency, for example), IB will win.  You can't 
approach either server as if it was a drop-in replacement for the other.  
They are complicated pieces of software which require knowledge to use 
correctly.

> Maybe I should look at IB7 but company would not buy it. 

	I'm not trying to sell you on IB.  You should use whichever server 
you like + works for you.  But if you want to know how to make IB perform 
well, I can help with that.

	-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