By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,313 Members | 2,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,313 IT Pros & Developers. It's quick & easy.

MS Sql 2000 vs. Pervasive SQL

P: n/a
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
Share this Question
Share on Google+
5 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.