on 12-21-2018 11:45 AM
Hi
I just imported free tables into a ADD vers. 12. The size of the memo tables increased 3 times:
adt size prior to importing: 198 MB, after 136 MB , because I deleted some fields, 1.1 million records
adm size prior to importing: 195 MB, after 737 MB , same data, how can this be possible?
Opening this table is couple of times slower then the free table. I did'nt change the memoblock size.
What can I do to improve the performance
I can't think of any obvious reason this would happen. What kind of memos are you storing? Large text fields? JPGs? PDFs? I'm wondering if the compression of some sort of binary got messed up.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
The data is pure ASCII text. I made some analysis:
select min(length(text)), => 10
max(length(text)), => 4752
avg(length(text)), => 197
sum(iif(length(text) <= 256, 1, 0 )), => 725620
sum(iif(length(text) between 257 and 1024, 1, 0 )), = >243721
sum(iif(length(text) > 1024, 1, 0 )) => 6850
from <table>
I suppose, quite normal scenario.
How did you import the tables?
Normally I would just right-click on "Tables" in Advantage Data Architect and select "Add existing table". This should have no impact on the file size at all.
Did you add or change encryption?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.