Page 1 of 1

Database problems

Posted: June 29th, 2007, 9:30
by 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?

Posted: June 29th, 2007, 9:39
by 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

Posted: June 29th, 2007, 10:11
by aviko
this is database from pci (not udma) version

Posted: June 29th, 2007, 10:21
by 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

Posted: June 30th, 2007, 6:15
by mori
hi, i need to help get file for hdd (pc 3000) please help
:D
i need to database pc 3000 thank you\
:D

Posted: June 30th, 2007, 11:24
by aviko
at start you should download resources from personal update box from acelab, if you buy chinese shit i will not help you sorry.

Posted: July 2nd, 2007, 12:17
by 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

Posted: July 15th, 2007, 3:27
by cryoborgofthevenus
dobrevjetser wrote: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 ?

Posted: July 15th, 2007, 4:00
by 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

Posted: July 15th, 2007, 4:13
by 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....

Posted: July 15th, 2007, 4:59
by dobrevjetser
I have to check this out.


I'll let you know.

Regards,

Dobre

Re:

Posted: July 17th, 2007, 3:12
by aviko
wawalab wrote: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.

Re: Database problems

Posted: July 17th, 2007, 10:27
by 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