MS Sql server 2000 -full text search

I'm trying to evaluate between using MS Sql server based full text search Vs open-source full-text search for our core product. Does anyone know of any previous benchmarks/comparisons between these two approaches? Appreciate any reply.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
Anantha,
Unfortunately, no such benchmarks/comparisons exists today and Microsoft has
never released any such benchmarks as well.
However, I have long been kicking around the idea of building a "SQL FTS
Benchmarking Toolkit" along the lines of a TPC Benchmark suite and I
submitted and abstract on it for the 2003 PASS conference. I'm assuming
you're comparing SQL Server 2000 FTS vs. MySQL FTS vs. PostgreSQL with is
TSearch2 or OpenFTS as I have researched all of these products or are you
considering other open-source full-text search products?
However, what you can do is build a sample database with publicly available
text data from the Moby lexicon project built by Grady Ward at
http://www.dcs.shef.ac.uk/research/ilash/Moby/ and then setup up a standard
benchmarking test. Note, this data is freely
available and is in the public domain, per Grady Ward. Additionally,
Microsoft as well as other RDBMS vendors, such as ORACLE and IBM compete in
standard TPC Benchmarking tests in order to determine which database is the
fastest, etc. while using a standard test suite of tools, database schema
and data, using the TPC Benchmark C (http://www.tpc.org/tpcc/detail.asp).
The TPC Benchmark that is closest to a "Full Text Search" TPC Benchmark is
TCP-W (http://www.tpc.org/tpcw/default.asp), but this too is mostly a
transactional web e-Commerce benchmark and not strictly for FTS queries.
Full Text Indexing (FTI) and Full Text Search (FTS) performance go hand in
hand along with the language of the text (Moby has word lists in five of
languages), the size (both row count and the amount of text per row) to
create a matrix of tests that will not only measure the FTI performance, but
will measure FTS queries from multiple clients issuing random FTS queries.
Additional factors, include both hardware and software configurations, for
example: the number, speed of the CPU's as well as the size and type of
L-cache per CPU. Other hardware configurations, includes the amount of RAM,
the number of disk controllers as well as the type of raid disk drives and
where the database files and FT Catalog files are placed. As you can see
this is a non-trivial effort and one I plan on documenting for my book on
this subject.
I continue to work on completing the "SQL FTS Benchmarking Toolkit" and
until it is completed, I'd recommend that you download some of the Moby test
files and develop a test database and tables and load this data into it and
then use the Microsoft provide client tool OSTRESS utility (download at:
http://support.microsoft.com/default...b;en-us;887057) use it to
measure the performance of multiple FTS queries from multiple clients
against your test database for comparisons against other open-source
full-text search for your core product.
Please feel free to contact me if you need additional details.
Regards,
John
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:#$cwriW1EHA.4004@.tk2msftngp13.phx.gbl...
> I'm trying to evaluate between using MS Sql server based full text search
Vs open-source full-text search for our core product. Does anyone know of
any previous benchmarks/comparisons between these two approaches?
Appreciate any reply.
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
|||John,
Thanks for your help. I'm trying to evaluate MS SQL Server 2000 FTS with open-source product/framework Lucene.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||You're welcome, Anantha,
If you're in comparing the open-source product/framework Lucene with SQL
Server 2000 FTS (both very different implementations of Full Text Search),
you may be interested in DotLucene - The Open Source Search Engine for .NET
at: http://openlucene.net/. Also, keep in mind if you're goal is to do full
text search of documents (MS Word, HTML, etc.) stored outside of SQL Server
tables, you can also use the Windows Indexing Service and setup a Linked
Server (via MSIDXS OLEDB provider) for other data stored in SQL Server.
Regards,
John
"Anantha Padmanabhan" <ananthapus@.hotmail.com> wrote in message
news:e1Z8S8Z1EHA.3840@.tk2msftngp13.phx.gbl...
> John,
> Thanks for your help. I'm trying to evaluate MS SQL Server 2000 FTS with
open-source product/framework Lucene.
>
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...
sql

MS SQL Developer Edition vs MS SQL Production Edition

Hi,
I am not very knowledgable of the MS SQL Server 2000 product range, but
according to a developing team we are in contact with, they have an
application experiencing long query times when several users are performing
queries against their MS SQL Server, which is a Developer Edition version of
MS SQL. As we're soon going to go live with the application, I would like to
know the differences between Developer Edition and any of the Production
Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
believe that a Production Edition have better performance, scalability and
stability compared to the Developer Edition, but this is just my thoughts.
Can someone please let me know the major differencies between Production
Editions and Developer Edition. Do you think that we will notice any
performance improvements moving to MS SQL Server Std./Ent. Edition?
Thanks in advance
// BjörnWith the new SQL 2005 product, it's hard to find informations about SQL 2000
on Microsoft website.
Take a look:
http://www.mssqlcity.com/FAQ/General/sql_server_2000_editions.htm
And for the new SQL 2005, take a look here:
http://www.microsoft.com/sql/editions/default.mspx
Carlos A.
"Björn Pettersson" wrote:
> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are performing
> queries against their MS SQL Server, which is a Developer Edition version of
> MS SQL. As we're soon going to go live with the application, I would like to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
> Thanks in advance
> // Björn|||"Björn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:21181F56-24A3-4E0A-8C9E-CEE43E91C5AA@.microsoft.com...
> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are
> performing
> queries against their MS SQL Server, which is a Developer Edition version
> of
> MS SQL. As we're soon going to go live with the application, I would like
> to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely
> to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
>
No. Developer edition is exactly the same as Enterprise Edition, exept for
the license. If an app performs poorly on Developer Edition it will not
perform any better on Enterprise.
David

MS SQL Developer Edition vs MS SQL Production Edition

Hi,
I am not very knowledgable of the MS SQL Server 2000 product range, but
according to a developing team we are in contact with, they have an
application experiencing long query times when several users are performing
queries against their MS SQL Server, which is a Developer Edition version of
MS SQL. As we're soon going to go live with the application, I would like to
know the differences between Developer Edition and any of the Production
Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
believe that a Production Edition have better performance, scalability and
stability compared to the Developer Edition, but this is just my thoughts.
Can someone please let me know the major differencies between Production
Editions and Developer Edition. Do you think that we will notice any
performance improvements moving to MS SQL Server Std./Ent. Edition?
Thanks in advance
// Bj?rnWith the new SQL 2005 product, it's hard to find informations about SQL 2000
on Microsoft website.
Take a look:
http://www.mssqlcity.com/FAQ/Genera...00_editions.htm
And for the new SQL 2005, take a look here:
http://www.microsoft.com/sql/editions/default.mspx
Carlos A.
"Bj?rn Pettersson" wrote:

> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are performin
g
> queries against their MS SQL Server, which is a Developer Edition version
of
> MS SQL. As we're soon going to go live with the application, I would like
to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely t
o
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
> Thanks in advance
> // Bj?rn|||"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:21181F56-24A3-4E0A-8C9E-CEE43E91C5AA@.microsoft.com...
> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are
> performing
> queries against their MS SQL Server, which is a Developer Edition version
> of
> MS SQL. As we're soon going to go live with the application, I would like
> to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely
> to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
>
No. Developer edition is exactly the same as Enterprise Edition, exept for
the license. If an app performs poorly on Developer Edition it will not
perform any better on Enterprise.
David

MS SQL Developer Edition vs MS SQL Production Edition

Hi,
I am not very knowledgable of the MS SQL Server 2000 product range, but
according to a developing team we are in contact with, they have an
application experiencing long query times when several users are performing
queries against their MS SQL Server, which is a Developer Edition version of
MS SQL. As we're soon going to go live with the application, I would like to
know the differences between Developer Edition and any of the Production
Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
believe that a Production Edition have better performance, scalability and
stability compared to the Developer Edition, but this is just my thoughts.
Can someone please let me know the major differencies between Production
Editions and Developer Edition. Do you think that we will notice any
performance improvements moving to MS SQL Server Std./Ent. Edition?
Thanks in advance
// Bj?rn
With the new SQL 2005 product, it's hard to find informations about SQL 2000
on Microsoft website.
Take a look:
http://www.mssqlcity.com/FAQ/General...0_editions.htm
And for the new SQL 2005, take a look here:
http://www.microsoft.com/sql/editions/default.mspx
Carlos A.
"Bj?rn Pettersson" wrote:

> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are performing
> queries against their MS SQL Server, which is a Developer Edition version of
> MS SQL. As we're soon going to go live with the application, I would like to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
> Thanks in advance
> // Bj?rn
|||"Bjrn Pettersson" <BjrnPettersson@.discussions.microsoft.com> wrote in
message news:21181F56-24A3-4E0A-8C9E-CEE43E91C5AA@.microsoft.com...
> Hi,
> I am not very knowledgable of the MS SQL Server 2000 product range, but
> according to a developing team we are in contact with, they have an
> application experiencing long query times when several users are
> performing
> queries against their MS SQL Server, which is a Developer Edition version
> of
> MS SQL. As we're soon going to go live with the application, I would like
> to
> know the differences between Developer Edition and any of the Production
> Editions, ex. MS SQL Server Standard or Enterprise Edition. It is likely
> to
> believe that a Production Edition have better performance, scalability and
> stability compared to the Developer Edition, but this is just my thoughts.
> Can someone please let me know the major differencies between Production
> Editions and Developer Edition. Do you think that we will notice any
> performance improvements moving to MS SQL Server Std./Ent. Edition?
>
No. Developer edition is exactly the same as Enterprise Edition, exept for
the license. If an app performs poorly on Developer Edition it will not
perform any better on Enterprise.
David

MS Sql 2000 vs. Pervasive SQL

I am using Maximizer Enterprise 8.0 as my companies CRM solution. Currently
we are using the included Pervasive SQL that shipps with the product. Is
there someone out that who could tell me if there are any performance
benefits to switching the Pervasive Engine with a Microsoft SQL engine.

Regards

JesusChuy wrote:

> I am using Maximizer Enterprise 8.0 as my companies CRM solution. Currently
> we are using the included Pervasive SQL that shipps with the product. Is
> there someone out that who could tell me if there are any performance
> benefits to switching the Pervasive Engine with a Microsoft SQL engine.
> Regards
> Jesus
>
Tell us more about your environment. How big is the database?
If I had to guess, i'd say it's not that big if you're running a CRM
package on it.
Pervasive is a really nice SQL database, especially for the price.
It's very reliable, I've seen them running for many years with no
problems. For most small/medium sized businesses, Pervasive is just
fine. Performance is close to if not better in some respects to MS-SQL.

So, what do you need? What features do you require?

It all depends....

If it works, don't fix it....rule #1|||I currenlty have about 50 users accessing the Pervasive Database. The
database is really just a glorified address book with notes, so it's really
not doing a lot of crunching. I do notice though that at peak usage times
certain larger fields (ie notes filed) takes a while to populate. Also we
have a couple of applications that are currently using MSDE and we would
like to consolidate those with one SQL dbase.

"pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@.com.com> wrote in message
news:am5rd.25232$fC4.11701@.newssvr11.news.prodigy. com...
> Chuy wrote:
>> I am using Maximizer Enterprise 8.0 as my companies CRM solution.
>> Currently we are using the included Pervasive SQL that shipps with the
>> product. Is there someone out that who could tell me if there are any
>> performance benefits to switching the Pervasive Engine with a Microsoft
>> SQL engine.
>>
>> Regards
>>
>> Jesus
> Tell us more about your environment. How big is the database?
> If I had to guess, i'd say it's not that big if you're running a CRM
> package on it.
> Pervasive is a really nice SQL database, especially for the price.
> It's very reliable, I've seen them running for many years with no
> problems. For most small/medium sized businesses, Pervasive is just fine.
> Performance is close to if not better in some respects to MS-SQL.
> So, what do you need? What features do you require?
> It all depends....
> If it works, don't fix it....rule #1
>|||Chuy wrote:
> I currenlty have about 50 users accessing the Pervasive Database. The
> database is really just a glorified address book with notes, so it's really
> not doing a lot of crunching. I do notice though that at peak usage times
> certain larger fields (ie notes filed) takes a while to populate. Also we
> have a couple of applications that are currently using MSDE and we would
> like to consolidate those with one SQL dbase.
>
sounds like you may just need to do some performance tuning.
which version of pervasive are u running?
Have you ever tuned this database for your environment?
Do you know how to do performance tuning on your version of Pervasive?

As far as the MSDE, I'm sure there are methods for intergrating that to
pervasive. Have you tried reading their docs or looking at the btrieve
newsgroup? comp.databases.btrieve
it's a pretty flexible database... as all good quality databases should be!

You can also try calling their sales people, they may be able to find
that out for you. It may be as simple as running the newest version.
I know for a dual-CPU license on Netware 6.0, the license was around
$3500 (last summer). It's price is very reasonable compared to MS-SQL.
It's got clustering, replication and all that enterprise class stuff -
if you need it.|||I have limited experiences with Databases, so no I am not familiar with
performance tuning. I have been in the Pervasive SQL management utility
which allows for tweaking of all kinds of settings that I am not positive
what they do. I dare not mess with it if I don't understand it. Do you
have any recommendations for tweaking it, or are there any utils to sniff
out the SQL Dbase access.

Jesus

"pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@.com.com> wrote in message
news:BKprd.39445$Al3.17911@.newssvr30.news.prodigy. com...
> Chuy wrote:
>> I currenlty have about 50 users accessing the Pervasive Database. The
>> database is really just a glorified address book with notes, so it's
>> really not doing a lot of crunching. I do notice though that at peak
>> usage times certain larger fields (ie notes filed) takes a while to
>> populate. Also we have a couple of applications that are currently using
>> MSDE and we would like to consolidate those with one SQL dbase.
>>
>>
> sounds like you may just need to do some performance tuning.
> which version of pervasive are u running?
> Have you ever tuned this database for your environment?
> Do you know how to do performance tuning on your version of Pervasive?
> As far as the MSDE, I'm sure there are methods for intergrating that to
> pervasive. Have you tried reading their docs or looking at the btrieve
> newsgroup? comp.databases.btrieve
> it's a pretty flexible database... as all good quality databases should
> be!
> You can also try calling their sales people, they may be able to find that
> out for you. It may be as simple as running the newest version.
> I know for a dual-CPU license on Netware 6.0, the license was around $3500
> (last summer). It's price is very reasonable compared to MS-SQL.
> It's got clustering, replication and all that enterprise class stuff - if
> you need it.|||Chuy wrote:
> I have limited experiences with Databases, so no I am not familiar with
> performance tuning. I have been in the Pervasive SQL management utility
> which allows for tweaking of all kinds of settings that I am not positive
> what they do. I dare not mess with it if I don't understand it. Do you
> have any recommendations for tweaking it, or are there any utils to sniff
> out the SQL Dbase access.

At this point, I'd suggest you don't mess with it.
You need a good programmer or database consultant (with Pervasive
experience) to work on your database. It should be a quick visit, most
of the time performance tuning for a small environment doesn't take long
(50-users is relatively small for a RDMBS).
It could be something as simple as rebuilding your indexes - but that's
just a guess. You'd need to gather information like what version of
Pervasive you're running on as well as what patch level (if any), what
OS the database is running on, available disk space, amount of RAM on
that database server, stuff like this.

Where are you located? I do IT consulting - we do have remote access
DBA services too.

http://www.atechbusinesssolutions.com

Oskar

my cell is 832-212-2675

> Jesus
> "pheonix1t" <pheonix1tAThoustonDOTrrDOTcom@.com.com> wrote in message
> news:BKprd.39445$Al3.17911@.newssvr30.news.prodigy. com...
>>Chuy wrote:
>>
>>>I currenlty have about 50 users accessing the Pervasive Database. The
>>>database is really just a glorified address book with notes, so it's
>>>really not doing a lot of crunching. I do notice though that at peak
>>>usage times certain larger fields (ie notes filed) takes a while to
>>>populate. Also we have a couple of applications that are currently using
>>>MSDE and we would like to consolidate those with one SQL dbase.
>>>
>>>
>>
>>sounds like you may just need to do some performance tuning.
>>which version of pervasive are u running?
>>Have you ever tuned this database for your environment?
>>Do you know how to do performance tuning on your version of Pervasive?
>>
>>As far as the MSDE, I'm sure there are methods for intergrating that to
>>pervasive. Have you tried reading their docs or looking at the btrieve
>>newsgroup? comp.databases.btrieve
>>it's a pretty flexible database... as all good quality databases should
>>be!
>>
>>You can also try calling their sales people, they may be able to find that
>>out for you. It may be as simple as running the newest version.
>>I know for a dual-CPU license on Netware 6.0, the license was around $3500
>>(last summer). It's price is very reasonable compared to MS-SQL.
>>It's got clustering, replication and all that enterprise class stuff - if
>>you need it.
>>
>>
>

MS SQL 2000 license

Hi All,
I am new to MS SQL 2000 and would like to get the license
information of the product. My company currently decided on MS SQL 2000
(not MS SQL 2005) and would like to have it as a database that provides
data to the general public on internet. I wonder what edition I should
get? It will be on one processor only. Will standard edition work? Or
it must be enterprise edition?
Thanks in advance,
Win
Hi,
The version standard of sql server 2000 I believe that go well for your
requirements.
It can support a lot of database in a petition and does not expect a license
to CPU.
I work in a business ISP that the utilization without problems for the
actual customers.
The main features you can find them to the address
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
Bye

MS SQL 2000 license

Hi All,
I am new to MS SQL 2000 and would like to get the license
information of the product. My company currently decided on MS SQL 2000
(not MS SQL 2005) and would like to have it as a database that provides
data to the general public on internet. I wonder what edition I should
get? It will be on one processor only. Will standard edition work? Or
it must be enterprise edition?
Thanks in advance,
WinHi,
The version standard of sql server 2000 I believe that go well for your
requirements.
It can support a lot of database in a petition and does not expect a license
to CPU.
I work in a business ISP that the utilization without problems for the
actual customers.
The main features you can find them to the address
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
Bye

MS SQL 2000 license

Hi All,
I am new to MS SQL 2000 and would like to get the license
information of the product. My company currently decided on MS SQL 2000
(not MS SQL 2005) and would like to have it as a database that provides
data to the general public on internet. I wonder what edition I should
get? It will be on one processor only. Will standard edition work? Or
it must be enterprise edition?
Thanks in advance,
WinHi,
The version standard of sql server 2000 I believe that go well for your
requirements.
It can support a lot of database in a petition and does not expect a license
to CPU.
I work in a business ISP that the utilization without problems for the
actual customers.
The main features you can find them to the address
http://msdn.microsoft.com/library/d...br />
8dbn.asp
Bye