Addendum. After looking further it appears that the reparsing is happening
independently of triggering. In this case, the reparsing occurs 30,502
times for every view and trigger I have examined. Only one trigger appears
in the 3.7.5 listing and it is parsed exactly 1 time.
3.7.5
CREATE TRIGGER error_warning_after_delete after delete on
local_errors_warnings begin insert into local_error_warning_deletions
values ( old.error_warning_oid ); update alerter_links
set is_dirty = 1 where sequence_instance_oid =
old.sequence_instance_oid and response_definition_oid in (
select response_definition_oid from behavior_independents
where behavior_oid = old.behavior_oid ); end
Times called: 1
Cumulative Allocated Memory: 5,960
Count of _malloc Calls: 56
Cumulative Reallocated Memory: 0
Count of _realloc Calls: 0
Cumulative Reallocated Memory where nil: 0
Count of _realloc Calls where nil: 0
Count of _free Calls: 32
Cumulative _mallocs by size
<= 1kb: 3,304 bytes (54 count; 61 avg)
1kb to 4kb: 2,656 bytes (2 count; 1,328 avg)
4bk to 8kb: 0 bytes (0 count; NAN avg)
8bk to 16kb: 0 bytes (0 count; NAN avg)
16bk to 32kb: 0 bytes (0 count; NAN avg)
32bk to 64kb: 0 bytes (0 count; NAN avg)
64bk to 128kb: 0 bytes (0 count; NAN avg)
128kb to 256kb: 0 bytes (0 count; NAN avg)
256kb to 512kb: 0 bytes (0 count; NAN avg)
512kb to 1024kb: 0 bytes (0 count; NAN avg)
> 1mb: 0 bytes (0 count; NAN avg)
No reallocs
No reallocs of nil pointers
---
3.7.6
CREATE TRIGGER error_warning_after_delete after delete on
local_errors_warnings begin insert into local_error_warning_deletions
values ( old.error_warning_oid ); update alerter_links
set is_dirty = 1 where sequence_instance_oid =
old.sequence_instance_oid and response_definition_oid in (
select response_definition_oid from behavior_independents
where behavior_oid = old.behavior_oid ); end
Times called: 30502
Cumulative Allocated Memory: 180,327,824
Count of _malloc Calls: 1,708,112
Cumulative Reallocated Memory: 0
Count of _realloc Calls: 0
Cumulative Reallocated Memory where nil: 0
Count of _realloc Calls where nil: 0
Count of _free Calls: 976,064
Cumulative _mallocs by size
<= 1kb: 99,314,512 bytes (1,647,108
count; 60 avg)
1kb to 4kb: 81,013,312 bytes (61,004 count;
1,328 avg)
4bk to 8kb: 0 bytes (0 count; NAN avg)
8bk to 16kb: 0 bytes (0 count; NAN avg)
16bk to 32kb: 0 bytes (0 count; NAN avg)
32bk to 64kb: 0 bytes (0 count; NAN avg)
64bk to 128kb: 0 bytes (0 count; NAN avg)
128kb to 256kb: 0 bytes (0 count; NAN avg)
256kb to 512kb: 0 bytes (0 count; NAN avg)
512kb to 1024kb: 0 bytes (0 count; NAN avg)
> 1mb: 0 bytes (0 count; NAN avg)
No reallocs
No reallocs of nil pointers
---
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
