File Size Increased...???

Hi..

We Are using Lytec a medical Billing Software...Which Uses Pervasive as its database..

We Have recently Converted Our Lytec 2001 to Lytce XE...

The size of some of the files tripled...


example...

File A
                                                Old Structure                                          New Structure
Record length                             892                                                      1105        


With The Number of records remaining the same..

The Size of the Files trippled

Before  220 MB..Now 660 Mb..

any suggestions on this...



LVL 7
mikkilineniAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mirtheilCommented:
That's  pretty significant increase.  How many records are in the table?  I created a table with an 1105 byte record, addeded 12,000 records and my table was only 880 KB.
Also, what happens if you rebuild the data file? Does the size drop?    
0
mikkilineniAuthor Commented:
I have 450000 records..
No when i rebuild  the file size doesn't Drop...
and the reseller says its Normal..But i don't belive him..
0
mirtheilCommented:
Can you post a BUTIL-STAT of the file?  If the reseller says it's normal, then that's possible.  Especially if a rebuild didn't help.
0
Brendt HessSenior DBACommented:
THe most likely reasons for that significant an increase:

(1)  Page size:  In Btrieve, the default page size id 4096 bytes.  With the old structure, 4 records would fit per page.  The new only allows 3 records per page.  Automatic increase of +33 percent

(2) Indexes:  If there were a significant number of indexes added, this could easily add to the table size.  As a (bad) example, I have seen a reasonably large table with 20+ indexes go from about 700K to about 2MB just by adding indexes.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
wdabbsCommented:
Lytec de-compressed the data files in the XE version. They were told that this would not affect the performance by Pervasive. However, this slowed down the reporting process in many cases. In the new 2004 version ther compressed the data files again. The file size that you are seeing is probably due to the de-compression
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.