Database problems

[aviko]

I have strange problems with database. First, when trying add new SA to base, message "Key violation", Tryed rebuild indexes and when indexed more than about 32800 records it comes with message "Not enough space" or something. Is this a limitation to 32768 records?

[dobrevjetser]

I dont think so, since they use a kind of SQL database, and these are just ment for huge databases. (i suppose you are talking about udma version)

I guess your harddisk has plenty of space left

I tried to look in my database, but the menus are still in Russian there. So i cannot say how many records i have.

Perhaps somebody else can help.

Regards,

Dobre

[aviko]

this is database from pci (not udma) version

[dobrevjetser]

OK, that one was based on paradox 5, which can handle up to 2 billion records per file, BUT the file-size is limited to two gigabyte!

I think that last condition is your problem.

Regards,


Dobre

[mori]

hi, i need to help get file for hdd (pc 3000) please help

i need to database pc 3000 thank you\

[aviko]

at start you should download resources from personal update box from acelab, if you buy chinese shit i will not help you sorry.

[wawalab]

hi aviko:
for your trouble can try set "vivtual memory".
for example, if your physics memory is 256MB,
you can set initial size(MB) to 372, then maximum size(MB) to 4096.
wawalab

[cryoborgofthevenus]

OK, that one was based on paradox 5, which can handle up to 2 billion records per file, BUT the file-size is limited to two gigabyte!

I think that last condition is your problem.

Regards,


Dobre

Dobre
Is it possible to divide the database when it's already created ? Lets say I have about 1.8 Gb now. And this information about 2 Gb limitation is worth worrying, how to split the database ?

[dobrevjetser]

I think you can do it if you own paradox 5.0 or higher.
I haven't tried it yet, but i can do it this week.
I'll post the result here.

Regards,

Dobre

[cryoborgofthevenus]

Thanks Dobre.

However I have a big questions...

Should we backup the database in .pcr formats only? Is it possible to backup the database in .frm files ?

I was afraid that this database can not be recognized by Paradox....

[dobrevjetser]

I have to check this out.


I'll let you know.

Regards,

Dobre

[aviko]

hi aviko:
for your trouble can try set "vivtual memory".
for example, if your physics memory is 256MB,
you can set initial size(MB) to 372, then maximum size(MB) to 4096.
wawalab

I have 2gb of ram
I think i found problem, in marvel tree there is a folder that contains all folders from this tree that makes neverending loop. but have no idea how to fix it.

[dobrevjetser]

OK, I did a little research.

The database can be divided, but then you'll have to write you own software to do it (e.g. with visual basic).
This is because they work with two files; the first is the folder database, which stores the folder names.
The second is the real database, which stores all modules etc... but which references to folder.db so that each module knows to which folder it belongs.

The pcr file is not recognised by paradox, so i think it is some proprietary format they use.
So best to backup the whole database.

Regards,

Dobre