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.