Accessing a paradox table from a C# application...

Hi everyone,
First off, I am very new to using Paradox tables, so I am stumped as
to how I should go about addressing these problems.

Anyway, I have a C# application that needs to access a Paradox
database over a network (through an ODBC connection). I have
successfully been able to do this in the past, but when I tried to
deploy a change this morning, the performance was intolerable and even
crashed my application. At first, I thought that I simply couldn't
connect, but it turns out that the queries are not performing well.

For example, if I run the following query:
SELECT TOP 1 * FROM ModelSer
or even:
SELECT TOP 1000 * FROM ModelSer

the query runs fairly well (the latter is slower, obviously).

Now, the table is (supposed) to be set to have the model, serial, and
timestamp set as the primary key. This would lead me to expect that
if I try this query:
SELECT TOP 1 * FROM ModelSer ORDER BY Timestamp

....that it would run fairly quickly. However, that wasn't the case.
If I used a test database locally, it took me 2 minutes to get a
response. At first, I noticed that I didn't have BDE installed. I
installed it and noticed no performance difference. However, if I
delete the .PX file corresponding to the table, the performance is
much better. When I try to restructure it with the primary keys, the
performance sucks again.

I have doing this kind of thing for about 6 months, but I can't quite
get a handle on what is going on. Any advice would be greatly
appreciated.

Sincerely,
Jason Pell

.

Relevant Pages

  • Re: Accessing a paradox table from a C# application...
    ... I would get a copy of Paradox and play around with restructuring the table and indexes and see what happens to query speed. ... There are several threads on the optimal way to set up a network. ... SELECT TOP 1000 * FROM ModelSer ...
    (comp.databases.paradox)
  • Accessing a paradox table from a C# application...
    ... First off, I am very new to using Paradox tables, so I am stumped as ... SELECT TOP 1000 * FROM ModelSer ... the query runs fairly well ... timestamp set as the primary key. ...
    (comp.databases.paradox)
  • Re: How do I subtract records in one table from another table
    ... >I'm having trouble making full sense of your question. ... >Create a query that includes both tables and join the ... >keys.Only include the primary key of the new table in the ... >> Until I changed to Access, I had been using Paradox to ...
    (microsoft.public.access.gettingstarted)
  • Re: Number of Records
    ... Paradox query process but seem to remember it can generate a lot of traffic ... > Diamond Software Group ... > Diamond Sports Gems ...
    (comp.databases.paradox)
  • Re: Accessing a paradox table from a C# application...
    ... SELECT TOP 1 * FROM ModelSer ORDER BY Timestamp ... How much faster is the query if you strip off the PX? ... The ODBC driver that I am using is the Microsoft Paradox ...
    (comp.databases.paradox)