cancel
Showing results for 
Search instead for 
Did you mean: 

Size of ADM Memo table

marcus_herz
Explorer
0 Kudos

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

michael_loop
Contributor
0 Kudos

Marcus,

If the table in question does not contain personal data, or if you can reproduce the behaviour with test data, we would like to see the table before and after the size increase.

If you have a support account with SAP, please create an incident. If not, please "follow" me. We can then work out a way to transfer the files through direct messages.

Accepted Solutions (0)

Answers (2)

Answers (2)

michael_loop
Contributor
0 Kudos

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.

marcus_herz
Explorer
0 Kudos

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.

michael_loop
Contributor
0 Kudos

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?

marcus_herz
Explorer
0 Kudos

Hi

I used a stored procedure which is about the same like the right click:

execute procedure sp_AddTableToDatabase('AGBTERM ' ,'AGBTERM.ADT ' , 3, 1, NULL, NULL );

The change of size happens after I dropped some fields. This is all I changed.