Recent content by MarkatLMFJ

I'm getting closer to my performance problem in another post --- I think ---- I think that I have some indexes in this database which are "btreive only" and don't come over to the relational side, probably because all the utilities that the application uses are still in cobol. How do I tell...

Oh yes, before I forget: 1) Pervasive 9.5 client & server 2) Database box is dual xeons with 4gb of RAM with RAID-5 on the database volume and RAID-1 on the OS volume with physically separate discs (obvivously); The box has the capability to be multi-homed but is not, using one connection to...

Howdy, I have what should be an easy query to execute but alas, it takes 30-40 seconds to actually run; lacking good analysis tools I'm having to make some guesses about where the fallbacks will be: Guess 1: One table has three fields (well a lot more, but only 3 that I am concerned with...

tc3596 --- can't help you out I'm fighting with psql myself; but I feel your pain bro, I'm a MS-SQL guru ML

Before I spend a while working out a query, does Pervasive support left and right outer joins? ML

does PSQL have a TABLES datatype that can be used in place of a temp table?, I thought I saw a tempdb on my pervasive system, what is the role of the tempdb database in Pervasive? ML

aaaargh! they're killing me!

In the Eclipse based PCC for 9.5, where did the query builder go, I can make a new SQL document and am good at SQL but the query builder sure speeds some things along.

I'm on 8.5 now, and I have about 58 clients in 2 buildings to upgrade tomorrow morning to 9.5 **adds to his list of reasons not to use pervasive** ML

Has anybody ever pushed out a pervasive upgrade through a GPO SW installation policy? If so, how did it go? Any trouble? ML

> It just sucks at running queries on large dbs. Anything will work faster when it just has to display data; but that doesn't do much good when you need dynamic reports and everything else in near real time without a lot of steps or needing a programmer/analyst involvement. I've used crystal...

Thanks, I'm reading the query analyzer docs you sent the link for.......initial thoughts are making me think I need to find a new job

Mirtheil, will running check database potentially harm anything?

I'm not working on crystal reports yet but I'm having dreadful query performance through ODBC for what should be a simple query (and I've not put the first join in it yet either) but since the schemas of the database are a 2NF at best and attempted 3NF showing a sequence of development over...

Howdy All, We are upgrading our credit card processing system to the enterprise based product, however, the product does not have modem failover if the internet is not available for processing. As such we are going to be upgrading our network to use a DIA circuit instead of DSL since it has...