473,320 Members | 1,580 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

Jesus
Jul 20 '05 #1
5 3672
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

Jul 20 '05 #2
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" <ph***************************@com.com> wrote in message
news:am*******************@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


Jul 20 '05 #3
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.
Jul 20 '05 #4
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" <ph***************************@com.com> wrote in message
news:BK*******************@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.

Jul 20 '05 #5
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" <ph***************************@com.com> wrote in message
news:BK*******************@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.


Jul 20 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Steve Hoyer | last post by:
I am working on bringing data into our SQL Server from a btreive database through Pervasive. It seems to work, mostly, but I am having problems with dates. At first, all date conversions from...
0
by: Classic Software, Inc. | last post by:
Need to get some Pervasive SQL or Btrieve data into a SQL Server database? For those needing to do so, we sell a very useful tool for Btrieve and Pervasive SQL Databases. Has an explorer type...
5
by: Alex Le Dain | last post by:
What is the best way to access a Pervasive database on another machine? cheers, Alex.
0
by: Classic Software, Inc. | last post by:
Need to get some Pervasive SQL or Btrieve data into a Microsoft Access database? For those needing to do so, we sell a very useful tool for Btrieve and Pervasive SQL Databases. Has an explorer...
1
by: samsonesau | last post by:
Hi All, Thanks in advance for the help. We are considering a new Project. This project is going to be totally web based. Currently my company is using Pervasive SQL 2000i for there ERP...
0
by: jan82 | last post by:
I receive the following error when trying to connect to a Pervasive database through ODBC: ERROR No available transport protocol for the Pervasive Network Services Layer. ERROR Driver's...
0
by: jan82 | last post by:
I receive the following error when trying to connect to a Pervasive database through ODBC: ERROR No available transport protocol for the Pervasive Network Services Layer. ERROR Driver's...
7
by: bryant | last post by:
Hi all. I am new to ASP and working in Expression Web. The following query displays the information I need in the gridview for a single record. SELECT "OE_HDR"."ORD_NO", "OE_HDR"."CUST_NAM",...
1
by: bailiss | last post by:
I am trying to save the " (inch mark) and ' (foot mark) into a database. I am not using MySQL regrettably. Instead, I have to use a Pervasive SQL database, version 8.5. The user is supposed to...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.