[PEDA] DataBase Size too big!
After designing a PCB in 99SE SP6 and my database file keeps getting bigger. Of coarse I always save different file names of my design every so often. But here is my question, after I have deleted all the extra files and deleted my recycle bin files why is my database file still very large? I could start a new database with the extracted .pcb file and it seems to keep all the rules and preferences, but is this the only way? I know this has been discussed somewhere, I just couldn't find it in the archive. Thanks, Lomax always has good answersnay quick answers? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] DataBase Size too big!
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. Click on the down arrow to the left of the file menu then go to design utilities. Click on the compact tab and browse to your database. AFAIK, access databases don't actually delete information until manually compacted. BTW, the design must be closed in the main explorer window for this to work. Darcy -Original Message- From: Michael Biggs [mailto:[EMAIL PROTECTED] Sent: May 10, 2004 9:20 AM To: Protel EDA Forum Subject: [PEDA] DataBase Size too big! After designing a PCB in 99SE SP6 and my database file keeps getting bigger. Of coarse I always save different file names of my design every so often. But here is my question, after I have deleted all the extra files and deleted my recycle bin files why is my database file still very large? I could start a new database with the extracted .pcb file and it seems to keep all the rules and preferences, but is this the only way? I know this has been discussed somewhere, I just couldn't find it in the archive. Thanks, Lomax always has good answersnay quick answers? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] DataBase Size too big!
-Original Message- From: Michael Biggs [mailto:[EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:20 PM To: Protel EDA Forum Subject: [PEDA] DataBase Size too big! After designing a PCB in 99SE SP6 and my database file keeps getting bigger. Of coarse I always save different file names of my design every so often. But here is my question, after I have deleted all the extra files and deleted my recycle bin files why is my database file still very large? I could start a new database with the extracted .pcb file and it seems to keep all the rules and preferences, but is this the only way? I know this has been discussed somewhere, I just couldn't find it in the archive. Michael Have you compacted the database? Are you using DDB file system? The DDB database size grows at an exponential rate if not compacted at close. Try the little un-named 'Arrow Down' button on the top left of the window, drop down to 'Design Utilities' and you will get a 'Compact Repair Box' I would suggest first backup your database to another location, then first run a 'repair' pass, then run 'compact' After that check the box for 'Perform Compact After Closing Design' box and the operation will be automatic after each session is closed. How big is your DDB file? You can export / import rules from within the PCB editor DesignRulesMenu or Right Click on workspaceRulesMenu Good luck Best Regards John A. Ross RSD Communications ltd Email [EMAIL PROTECTED] WWWhttp://www.rsd.tv == * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] DataBase Size too big!
I think you are looking for Compact and Repair. You should be able to compact it from here. This is under design utilities under the arrow symbol in the main menu. I'd have it all backed up first, just for fun. ---Phil MB After designing a PCB in 99SE SP6 and my database file keeps getting MB bigger. Of coarse I always save different file names of my design every MB so often. But here is my question, after I have deleted all the extra MB files and deleted my recycle bin files why is my database file still MB very large? I could start a new database with the extracted .pcb file MB and it seems to keep all the rules and preferences, but is this the only MB way? MB I know this has been discussed somewhere, I just couldn't find it in MB the archive. MB Thanks, MB Lomax always has good answersnay quick answers? * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Forum Guidelines Rules: * http://www.techservinc.com/protelusers/forumrules.html * * Browse or Search previous postings: * http://www.mail-archive.com/[EMAIL PROTECTED] * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database size
Now that is bizarre! I opened the database this morning, closed it, and it has now dropped in size from 25MB, to 7MB. The compact on close facility was enabled the whole time. Eh?! I get the feeling I will never know the answer the that little mystery. Mike. Dennis Saputelli [EMAIL PROTECTED] on 06/08/2001 17:39:09 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size run the compact utility on it Dennis Saputelli [EMAIL PROTECTED] wrote: Hmm Doesn't sound like thats it. The recycle bin is empty, and the backups are not stored in the main database file. I don't know what else could have filled up that file. Mike. [EMAIL PROTECTED] on 06/08/2001 15:30:06 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size In a message dated 8/6/01 10:27:05 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Could somebody please shed some light on this matter for me. I have a database which consists solely of libraries and templates. On Friday the database size was approximately 10MB. Today, I did a couple of additions to two of the libraries. This was minor data compared to the database size. The database after compression, now exceeds 23MB. How on earth is this possible? Most likely you've got auto-backups turned on, or maybe you need to flush your recycle bin. Steve Hendrix -- ___ www.integratedcontrolsinc.comIntegrated Controls, Inc. tel: 415-647-04802851 21st Street fax: 415-647-3003San Francisco, CA 94110 * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * - or email - * mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database size
This can happen when (occasionly for whatever reason) the temporary database.ldb-file is not deleted. Then you are logged in to the database two times with the same user name on the same machine. This prevents Protel from compacting when you are closing the ddb because your Phantom still has opened it. With earlier service packs I could see this effect several times and had to help myself sometimes by manually delete the database.ldb-file in the Windows Explorer. Knock on wood, since service pack 4 or 5 I can't remember to have seen this again! Emanuel [EMAIL PROTECTED] wrote: Now that is bizarre! I opened the database this morning, closed it, and it has now dropped in size from 25MB, to 7MB. The compact on close facility was enabled the whole time. Eh?! I get the feeling I will never know the answer the that little mystery. Mike. Dennis Saputelli [EMAIL PROTECTED] on 06/08/2001 17:39:09 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size run the compact utility on it Dennis Saputelli [EMAIL PROTECTED] wrote: Hmm Doesn't sound like thats it. The recycle bin is empty, and the backups are not stored in the main database file. I don't know what else could have filled up that file. Mike. [EMAIL PROTECTED] on 06/08/2001 15:30:06 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size In a message dated 8/6/01 10:27:05 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Could somebody please shed some light on this matter for me. I have a database which consists solely of libraries and templates. On Friday the database size was approximately 10MB. Today, I did a couple of additions to two of the libraries. This was minor data compared to the database size. The database after compression, now exceeds 23MB. How on earth is this possible? Most likely you've got auto-backups turned on, or maybe you need to flush your recycle bin. Steve Hendrix -- ___ www.integratedcontrolsinc.comIntegrated Controls, Inc. tel: 415-647-04802851 21st Street fax: 415-647-3003San Francisco, CA 94110 -- MPL AG www.mpl.ch Emanuel Zimmermann [EMAIL PROTECTED] Manager RD Phone: +41 (0)56 483 34 34 Taefernstrasse 20 Fax: +41 (0)56 493 30 20 CH-5405 Daettwil * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * - or email - * mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database size
Thanks for that pointer. It seems that when somebody opens a PCB file on any computer on the network, and has a library file added that is in the library database, the .ldb file appears showing admin access for that computer. Under these circumstances, if I open, edit, and close the library database, the compact does not work, and the database bloates. All I need to do, is to remember to compact the database after changes, at a time when nobody else is logged on, so that the compact utility will work. Annoying, but at least I know what is happening, and what to do to fix it. Thanks, Mike. Emanuel Zimmermann [EMAIL PROTECTED] on 07/08/2001 08:50:23 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size This can happen when (occasionly for whatever reason) the temporary database.ldb-file is not deleted. Then you are logged in to the database two times with the same user name on the same machine. This prevents Protel from compacting when you are closing the ddb because your Phantom still has opened it. With earlier service packs I could see this effect several times and had to help myself sometimes by manually delete the database.ldb-file in the Windows Explorer. Knock on wood, since service pack 4 or 5 I can't remember to have seen this again! Emanuel [EMAIL PROTECTED] wrote: Now that is bizarre! I opened the database this morning, closed it, and it has now dropped in size from 25MB, to 7MB. The compact on close facility was enabled the whole time. Eh?! I get the feeling I will never know the answer the that little mystery. Mike. Dennis Saputelli [EMAIL PROTECTED] on 06/08/2001 17:39:09 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size run the compact utility on it Dennis Saputelli [EMAIL PROTECTED] wrote: Hmm Doesn't sound like thats it. The recycle bin is empty, and the backups are not stored in the main database file. I don't know what else could have filled up that file. Mike. [EMAIL PROTECTED] on 06/08/2001 15:30:06 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size In a message dated 8/6/01 10:27:05 AM Eastern Daylight Time, [EMAIL PROTECTED] writes: Could somebody please shed some light on this matter for me. I have a database which consists solely of libraries and templates. On Friday the database size was approximately 10MB. Today, I did a couple of additions to two of the libraries. This was minor data compared to the database size. The database after compression, now exceeds 23MB. How on earth is this possible? Most likely you've got auto-backups turned on, or maybe you need to flush your recycle bin. Steve Hendrix -- ___ www.integratedcontrolsinc.comIntegrated Controls, Inc. tel: 415-647-04802851 21st Street fax: 415-647-3003San Francisco, CA 94110 -- MPL AG www.mpl.ch Emanuel Zimmermann [EMAIL PROTECTED] Manager RD Phone: +41 (0)56 483 34 34 Taefernstrasse 20 Fax: +41 (0)56 493 30 20 CH-5405 Daettwil * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * - or email - * mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: [PEDA] Database size
Re: [PEDA] Database size
Andrew, I am using SP6, as are most of the users who access the library database that I control. It would seem, as I mentioned in an earlier message, that a .ldb file is being created, with admin status, for any person editing a PCB, with the library added. These people have not got the actual database open. Under these circumstances, I can edit and save, but the compact utility does not function, and the database quickly expands in size. Only once the .ldb file has disappeared, can I compact the database. Mike. Andrew J Jenkins [EMAIL PROTECTED] on 07/08/2001 12:10:18 Please respond to Protel EDA Forum [EMAIL PROTECTED] To: Protel EDA Forum [EMAIL PROTECTED] cc: Subject: Re: [PEDA] Database size On 09:50 AM 8/7/2001 +0200, Emanuel Zimmermann wrote: This can happen when (occasionly for whatever reason) the temporary database.ldb-file is not deleted. Then you are logged in to the database two times with the same user name on the same machine. This prevents Protel from compacting when you are closing the ddb because your Phantom still has opened it. With earlier service packs I could see this effect several times and had to help myself sometimes by manually delete the database.ldb-file in the Windows Explorer. If what you're saying is correct, this presents a very dangerous situation, wrt a PEDA customer's data integrity/security, and it wouldn't surprise me at all if this were eventually found to be at least one of the sources of the database corruptions that comes up now and again. Unfortunately, due to the occasionally for whatever reason problem, it'd be pretty hard to test/isolate the problem as a group...:( Knock on wood, since service pack 4 or 5 I can't remember to have seen this again! Emanuel That brings to mind a good question for Michael Binning... Mike, What version service pack is installed on your system? If it's v6, then Protel still has an important issue to clean up, especially if, as was implied in Emanuel's reply, the problem stems from an unknown and unexpected initiation of duplicate entrance(s) into the ddb from a single host. aj * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * To post a message: mailto:[EMAIL PROTECTED] * * To leave this list visit: * http://www.techservinc.com/protelusers/leave.html * - or email - * mailto:[EMAIL PROTECTED]?body=leave%20proteledaforum * * Contact the list manager: * mailto:[EMAIL PROTECTED] * * Browse or Search previous postings: * http://www.mail-archive.com/proteledaforum@techservinc.com * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
