Max File Sizes??

Karl Thompson

Delphi Developer

Sat, 13 Mar 2004 10:05:27 GMT

Max File Sizes??

Hi,

BDE 5.11/Delphi 5.0

Our Delphi application inserts scanned images into a Paradox 7 table. All of
a sudden it has stopped working. At the point the data is posted, the NT
4.0x 's task manager indicates that the application is consuming all the CPU
cycles. The application remain hung and it has to be killed via the Task
Manager.

This is what I'm wondering.....

I understand that the max size of an MB file is 2gb.

Currently, my file sizes are:

DB : 16,406kb

MB: 226,760kb

As I recall, Paradox DOS had a utility that allowed the administrator to set
a maximum file size. I don't see where this can be done via the current BDE
Config.

Is this even the problem? Did I miss something? Any suggestions?

Separately, is there a way to migrate the data from this table to a MS SQL
database? What tool/technique would be used to do this?

Thanks,
Karl

Team

Delphi Developer

Sat, 13 Mar 2004 10:39:59 GMT

Re:Max File Sizes??

You can vary the maximum size of the .DB file by changing the block size,
however, the default is a 2k block size which gives 128 mb maximum file size
and you are not close to that. The block size does not affect the size of
the .MB file which is 2 gb. I don't think your problem is related to the
maximum size of your table. You might try repairing the table with TUtility
and see if that makes a difference.

--
Bill
(TeamB cannot answer questions received via email)

Karl Thompso

Delphi Developer

Sat, 13 Mar 2004 11:10:08 GMT

Re:Max File Sizes??

Thanks for the clarification.

TUtility was the first thing that I tried. Any other ideas?

"Bill Todd (TeamB)" <bill.nos...@dbginc.com> wrote in message
news:3bafee98$1_2@dnews...

Quote

> You can vary the maximum size of the .DB file by changing the block size,
> however, the default is a 2k block size which gives 128 mb maximum file
size
> and you are not close to that. The block size does not affect the size of
> the .MB file which is 2 gb. I don't think your problem is related to the
> maximum size of your table. You might try repairing the table with
TUtility
> and see if that makes a difference.

> --
> Bill
> (TeamB cannot answer questions received via email)

Team

Delphi Developer

Sat, 13 Mar 2004 12:38:24 GMT

Re:Max File Sizes??

On Mon, 24 Sep 2001 22:05:27 -0400, "Karl Thompson" <ka...@pine-grove.com>
wrote:

Quote

>As I recall, Paradox DOS had a utility that allowed the administrator to set
>a maximum file size. I don't see where this can be done via the current BDE
>Config.

>Is this even the problem? Did I miss something? Any suggestions?

I have not used Paradox files for quite some time, but I seem to recall
that the limit was in the number of blocks which a database could hold.
This number is a fixed maximum limit, and the way you change the maximum
number of records was to increase the block size for the database file.
IIRC, this block size change must be done at the time the database/table
is created.

Quote

>Separately, is there a way to migrate the data from this table to a MS SQL
>database? What tool/technique would be used to do this?

You can use the Data Pump tool (if you have the Enterprise level of your
compiler) or you can write your own equivalent using TBatchMove components.
I have used the TBatchMove components in the past to migrate data from a
Paradox table into an MS-SQL Server ( version 6.0 ) server, as well as
into an Oracle v8 server for one of our reporting environments at work.

Jerry Bloomfield (TeamB)
--
http://www.teamb.com JersW...@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam
filters will probably just delete it anyway <g>)

Karl Thompso

Delphi Developer

Sat, 13 Mar 2004 17:10:40 GMT

Re:Max File Sizes??

Quote

>>Data Pump tool (if you have the Enterprise level of your
> compiler) <<<

Thanks. I do. I wasn't aware of Data Pump. Does it handle the data in blob
fields?

"Jerry Bloomfield (TeamB)" <JersW...@wwa.com> wrote in message
news:i0rvqto8876fr118j4fhd38gb304qurgpa@4ax.com...

Quote

> On Mon, 24 Sep 2001 22:05:27 -0400, "Karl Thompson" <ka...@pine-grove.com>
> wrote:

> >As I recall, Paradox DOS had a utility that allowed the administrator to
set
> >a maximum file size. I don't see where this can be done via the current
BDE
> >Config.

> >Is this even the problem? Did I miss something? Any suggestions?

> I have not used Paradox files for quite some time, but I seem to recall
> that the limit was in the number of blocks which a database could hold.
> This number is a fixed maximum limit, and the way you change the maximum
> number of records was to increase the block size for the database file.
> IIRC, this block size change must be done at the time the database/table
> is created.

> >Separately, is there a way to migrate the data from this table to a MS
SQL
> >database? What tool/technique would be used to do this?

> You can use the Data Pump tool (if you have the Enterprise level of your
> compiler) or you can write your own equivalent using TBatchMove
components.
> I have used the TBatchMove components in the past to migrate data from a
> Paradox table into an MS-SQL Server ( version 6.0 ) server, as well as
> into an Oracle v8 server for one of our reporting environments at work.

> Jerry Bloomfield (TeamB)
> --
> http://www.teamb.com JersW...@wwa.com
> Please do *NOT* send private e-mail without prior permission (my anti-spam
> filters will probably just delete it anyway <g>)

Team

Delphi Developer

Sat, 13 Mar 2004 21:41:43 GMT

Re:Max File Sizes??

Sorry, no other ideas.

--
Bill
(TeamB cannot answer questions received via email)

Other Threads

1. Max File Size or Record Count

2. Playing Avi's.. Max file size??

3. max size of a file under win9x/NT?

4. Max size of 32-bit DBASE files

5. Max size of dBASE DBT (memo) file???

6. Max Size For Pdx Files?

7. Team B - Please Explain Why 32MB Is Max TDS File Size

8. min stack size, max stack size and image base

9. BLOB max size?

10. D5 -tmemo - max size?