BDE creating large tables, URGENT!!,please help 
Author Message
 BDE creating large tables, URGENT!!,please help

Goodmorning to all,

We have developed a Delphi application for a client of ours, that is
located on a remote location. It uses a paradox database, that is located
on the same remote location. In the past, we encountered no problems. We
recently supplied the client with a new version of the program. The
database did not change.
In this new version, the problem occurs. When our client tries to start the
application from a workstation, it now takes 30 minutes before the
application appears on the screen. When we tried to investigate what the
executable is doing all this time, we discovered that Paradox is creating
large tables in the application's Temp directory (40-60 MB each). We
suppose that this may be the cause of the long starting time of the
application. The tables in the Temp directory have the following names:
_qsq1.db
_qsq2.db
etc

What we would like to know is the following:
Can this really be the cause of our problem
Why does Paradox create these tables
How can we prevent Paradox from creating these tables

Hope anyone has a solution for us because we are desparate!!!!

TIA,




Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

I Think these are temporary tables uses by Delphi when creating Result Sets
for complicated queries.

1. Are you using any new queries in your new version of the application.
2. Did you test it on a database of similar size to the clients data.

RCJ



Quote:
> The tables in the Temp directory have the following names:
> _qsq1.db
> _qsq2.db
> etc

> What we would like to know is the following:
> Can this really be the cause of our problem
> Why does Paradox create these tables
> How can we prevent Paradox from creating these tables

> Hope anyone has a solution for us because we are desparate!!!!

> TIA,





Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

Hello Richard,
Thanks for responding so quickly,

To answer your questions:

No I have not used new queries in my new version and yes it is tested on a
database of similar size to the clients data with the same result.

I tried dropping the question in Borlands lap but they only could tell me
that I have a problem(which I allready knew). It is correct to say that
these are temporary files but why they are created etc. is not available
from Borland.



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

<snip>

Quote:
>suppose that this may be the cause of the long starting time of the
>application. The tables in the Temp directory have the following names:
>_qsq1.db
>_qsq2.db
>etc

>What we would like to know is the following:
>Can this really be the cause of our problem
>Why does Paradox create these tables
>How can we prevent Paradox from creating these tables

Those temporary tables are used by TQuery's check if anything changed with
the original database. Corrupt tables might cause this.

        -- Kirk



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

Hello Kirk,

Thanks for looking at my problem. Unfortunately all tables
have been rebuild and verified and still the problem occurs.

Any suggestions ?

TIA,


BTW your email address seems to be incorrect. could not post to it.



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

The BDE creates temporary tables under the following conditions.

1) When running some queries.
2) When restructuring or packing a table by calling DbiDoRestructure.
3) When sorting a table.
4) When building indices.
5) When working with large BLOB's.

There may be other circumstances too. I have never heard of the
problem you describe.  Try rebuilding the tables with the table repair
utility.  If that does not cure the problem try single stepping
through the code in the project file and the main form's OnCreate
event handler to see if you can tell the exact point at which the
delay occurs. It would also be helpful to know what version of Delphi
and the BDE you are using and what kind of network the app is running
on.

Bill

(Sorry but TeamB cannot answer support questions received via email.)
(To send me email for any other reason remove .nospam from my address.)



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

Couple things...

1)Rename all PdoxUsrs.Net (you should find only one Net file...) file and
lock files (Paradox.lck  & pdoxusrs.lck) don't delete them...rename
them...(Also search the workstation for these files...You SHOULD not find
any PdoxUsrs.net files on the workstation...)

If that doesn't fix the problem go to step 2...

2) Rename all their database's and index's(actually renaming the directory
where the data is easier, then recreate the old directory and copy your test
data in this dir)...Copy your versions on to the server...See if the problem
persist....If the problem goes away...you can pretty much bet the problem is
in the tables or index...

If the problem is in the tables...blow away all index's and copy the data
into a new table one record at a time...(starting at the 1st record and
moving down in a for loop..., if it crashes...repeat but start at the last
record and move up...)

3)Also don't forget to check the users BDE settings of where the net file is
located...

Rick Peterson

Quote:

>Hello Kirk,

>Thanks for looking at my problem. Unfortunately all tables
>have been rebuild and verified and still the problem occurs.

>Any suggestions ?

>TIA,


>BTW your email address seems to be incorrect. could not post to it.



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

You are using NON live SQL queries.  The BDE accomplishes this by copying the
results to temporary tables on the local hard drive.

You can either : Change the private directory for the BDE to a network drive
(if space is an issue, but this will further slow your application).  OR you
can set your queries to be live (not always an option).  OR narrow your
queries to retrieve a managable # of records.

- Clinton R. Johnson



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

In further review, lose the TQUERYs and use TTABLES with ranges whereever
possible. Your performance increase will impress you.

- CLinton R. Johnson



Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

First of all, thanks everyone for responding.

Today I will try your suggestions. I allready built and verified every
table.
Did not solve a thing. I now am using Delphi 3.02 with BDE 4.01 and the
previous
version we delivered to our client (no problem at all) was with Delphi 3.0
and 3.0 from BDE.

The programm is running on a windows NT system 4.0 English version with
servicepack 3 on it.
The tables are not bigger than 10 mb, most of them are around 5mb.

Will be continued.......

Greetings to all,




Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

Remember Tutility is infamous for not finding and fixing 100% of all table
corruption...just because these utilities say there is no problem does not
mean there is no problem

Rick Peterson

Quote:

>First of all, thanks everyone for responding.

>Today I will try your suggestions. I allready built and verified every
>table.
>Did not solve a thing. I now am using Delphi 3.02 with BDE 4.01 and the
>previous
>version we delivered to our client (no problem at all) was with Delphi 3.0
>and 3.0 from BDE.

>The programm is running on a windows NT system 4.0 English version with
>servicepack 3 on it.
>The tables are not bigger than 10 mb, most of them are around 5mb.

>Will be continued.......

>Greetings to all,





Wed, 18 Jun 1902 08:00:00 GMT
 BDE creating large tables, URGENT!!,please help

In article


Quote:

>Remember Tutility is infamous for not finding and fixing 100% of all table
>corruption...just because these utilities say there is no problem does not
>mean there is no problem

>Rick Peterson

I've had tutility "fix" a table by nuking all the data in it.  Not desireable.
 I wrote my own recovery utilities.  Unfortunately, there is nothing wrong
here.  The BDE is acting normally and doing what it was told to do - the
instructions are in question here.  Technique that is.

- Clinton R. Johnson



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 12 post ] 

 Relevant Pages 

1. Urgent Help Need: CReate Large Table

2. Please help urgent: Installing BDE manually

3. HELP PLEASE: URGENT: Need help forming a multi table query

4. need help creating tables with BDE

5. help with very large tables please...

6. Large table update/vacuum PLEASE HELP!

7. paging through a very large table? please help

8. URGENT help please - need to limit results with multi table join

9. Urgent-Urgent Please help

10. Rebuild Table after crash - URGENT, please help

11. urgent - table ownerships/logins PLEASE HELP !

12. URGENT Please, Is anybody worked with SLIDER CONTROL, PLEASE HELP


 
Powered by phpBB® Forum Software