All times are UTC - 5 hours [ DST ]




Post new topic Reply to topic  [ 13 posts ] 
Author Message
 Post subject: Database problems
PostPosted: June 29th, 2007, 9:30 
Offline
User avatar

Joined: August 11th, 2005, 23:21
Posts: 92
Location: Poznan, Poland
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?


Top
 Profile  
 
 Post subject:
PostPosted: June 29th, 2007, 9:39 
Offline

Joined: December 27th, 2006, 10:15
Posts: 1852
Location: Belgium
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


Top
 Profile  
 
 Post subject:
PostPosted: June 29th, 2007, 10:11 
Offline
User avatar

Joined: August 11th, 2005, 23:21
Posts: 92
Location: Poznan, Poland
this is database from pci (not udma) version


Top
 Profile  
 
 Post subject:
PostPosted: June 29th, 2007, 10:21 
Offline

Joined: December 27th, 2006, 10:15
Posts: 1852
Location: Belgium
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


Top
 Profile  
 
 Post subject:
PostPosted: June 30th, 2007, 6:15 
Offline

Joined: June 30th, 2007, 5:44
Posts: 1
hi, i need to help get file for hdd (pc 3000) please help
:D
i need to database pc 3000 thank you\
:D


Top
 Profile  
 
 Post subject:
PostPosted: June 30th, 2007, 11:24 
Offline
User avatar

Joined: August 11th, 2005, 23:21
Posts: 92
Location: Poznan, Poland
at start you should download resources from personal update box from acelab, if you buy chinese shit i will not help you sorry.


Top
 Profile  
 
 Post subject:
PostPosted: July 2nd, 2007, 12:17 
Offline

Joined: May 1st, 2005, 10:12
Posts: 93
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


Top
 Profile  
 
 Post subject:
PostPosted: July 15th, 2007, 3:27 
Offline
User avatar

Joined: October 2nd, 2005, 0:30
Posts: 288
Location: Jakarta - Indonesia
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 ?


Top
 Profile  
 
 Post subject:
PostPosted: July 15th, 2007, 4:00 
Offline

Joined: December 27th, 2006, 10:15
Posts: 1852
Location: Belgium
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


Top
 Profile  
 
 Post subject:
PostPosted: July 15th, 2007, 4:13 
Offline
User avatar

Joined: October 2nd, 2005, 0:30
Posts: 288
Location: Jakarta - Indonesia
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....


Top
 Profile  
 
 Post subject:
PostPosted: July 15th, 2007, 4:59 
Offline

Joined: December 27th, 2006, 10:15
Posts: 1852
Location: Belgium
I have to check this out.


I'll let you know.

Regards,

Dobre


Top
 Profile  
 
 Post subject: Re:
PostPosted: July 17th, 2007, 3:12 
Offline
User avatar

Joined: August 11th, 2005, 23:21
Posts: 92
Location: Poznan, Poland
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.

_________________
This post was my opinion today. It cant be used against me in tomorrow or later. In addition, I reserve the right to change views without giving any reason.


Top
 Profile  
 
 Post subject: Re: Database problems
PostPosted: July 17th, 2007, 10:27 
Offline

Joined: December 27th, 2006, 10:15
Posts: 1852
Location: Belgium
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

_________________
Murphy was an optimist

Datarecovery in Belgium, Holland, France and Germany
Datarecoverytools http://www.drtools.eu


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 

All times are UTC - 5 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 22 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group