651 |
|
Opening inet://localhost/employee |
652 |
|
Database Open |
653 |
|
Employee Count = 42 |
654 |
< |
Transaction ID = 5281 |
654 |
> |
Transaction ID = 8337 |
655 |
|
Transaction is Read/Write |
656 |
|
Transaction Database Path = inet://localhost/employee |
657 |
< |
Transaction ID = 5281 |
658 |
< |
Oldest Interesting = 1895 |
659 |
< |
Oldest Action = 5280 |
660 |
< |
Oldest Snapshot = 5280 |
657 |
> |
Transaction ID = 8337 |
658 |
> |
Oldest Interesting = 8335 |
659 |
> |
Oldest Action = 8336 |
660 |
> |
Oldest Snapshot = 8336 |
661 |
|
Oldest Snapshot Number = 1 |
662 |
|
Lock Timeout = 0 |
663 |
|
Transaction Access = isc_info_tra_readwrite |
692 |
|
SALARY = 64,635.00 |
693 |
|
FULL_NAME = Johnson, Leslie |
694 |
|
|
695 |
< |
Current memory = 19,762,192 |
695 |
> |
Current memory = 19,762,400 |
696 |
|
Delta memory = 4,464 |
697 |
< |
Max memory = 19,807,520 |
698 |
< |
Elapsed time= 0.002 sec |
697 |
> |
Max memory = 19,807,728 |
698 |
> |
Elapsed time= 0.003 sec |
699 |
|
Cpu = 0.000 sec |
700 |
|
Buffers = 2048 |
701 |
|
Reads = 0 |
702 |
< |
Writes = 0 |
702 |
> |
Writes = 1 |
703 |
|
Fetches = 3 |
704 |
|
Select Count = 0 InsertCount = 1 UpdateCount = 0 DeleteCount = 0 |
705 |
|
Relation Name = EMPLOYEE |
2733 |
|
|
2734 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2735 |
|
|
2736 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269) |
2736 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2737 |
|
|
2738 |
|
|
2739 |
|
Shrink to 2:10 |
2749 |
|
|
2750 |
|
MYARRAY2 = Array: (0: 01/5/2020 12:00:00) (1: 01/5/2020 12:01:00) (2: 01/5/2020 12:02:00) (3: 01/5/2020 12:03:00) (4: 01/5/2020 12:04:00) (5: 01/5/2020 12:05:00) (6: 01/5/2020 12:06:00) (7: 01/5/2020 12:07:00) (8: 01/5/2020 12:08:00) (9: 01/5/2020 12:09:00) (10: 01/5/2020 12:10:00) (11: 01/5/2020 12:11:00) (12: 01/5/2020 12:12:00) (13: 01/5/2020 12:13:00) (14: 01/5/2020 12:14:00) (15: 01/5/2020 12:15:00) (16: 01/5/2020 12:16:00) |
2751 |
|
|
2752 |
< |
MYARRAY3 = Array: (0: 0) (1: 1.04) (2: 2.09) (3: 3.15) (4: 4.19) (5: 5.25) (6: 6.3) (7: 7.34) (8: 8.39) (9: 9.44) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.64) (14: 0.42) (15: 42.46) (16: 4269) |
2752 |
> |
MYARRAY3 = Array: (0: 0) (1: 1.05) (2: 2.1) (3: 3.15) (4: 4.2) (5: 5.25) (6: 6.3) (7: 7.35) (8: 8.4) (9: 9.45) (10: 10.5) (11: 11.55) (12: 12.6) (13: 13.65) (14: 0.42) (15: 42.46) (16: 4269) |
2753 |
|
|
2754 |
|
|
2755 |
|
|
2844 |
|
Version = 1: LI-V6.3.1.2692 Firebird 4.0 |
2845 |
|
Database is Read/Write |
2846 |
|
Database Created: 21/12/2021 10:52:59 |
2847 |
< |
Pages Used = 351 |
2848 |
< |
Pages Free = 62 |
2847 |
> |
Pages Used = 352 |
2848 |
> |
Pages Free = 61 |
2849 |
|
Server Memory = 19476112 |
2850 |
|
Forced Writes = 1 |
2851 |
|
Max Memory = 19506944 |
2853 |
|
Sweep Interval = 20000 |
2854 |
|
Logged in Users: SYSDBA, |
2855 |
|
Active Transaction Count = 0 |
2856 |
< |
Fetches = 1683 |
2856 |
> |
Fetches = 1698 |
2857 |
|
Writes = 6 |
2858 |
|
Reads = 97 |
2859 |
|
Page Writes = 3 |
2879 |
|
Table ID = 12 |
2880 |
|
Count = 24 |
2881 |
|
Table ID = 18 |
2882 |
< |
Count = 940 |
2882 |
> |
Count = 952 |
2883 |
|
Table ID = 20 |
2884 |
|
Count = 5 |
2885 |
|
Table ID = 28 |
2907 |
|
Event Signalled |
2908 |
|
First Event - usually ignored |
2909 |
|
Signal Event |
2910 |
+ |
Event Signalled |
2911 |
|
Event Counts: TESTEVENT, Count = 1 |
2912 |
|
Two more events |
2913 |
|
Call Async Wait |
2914 |
|
Async Wait Called |
2915 |
|
Event Signalled |
2915 |
– |
Event Signalled |
2916 |
|
Deferred Events Caught |
2917 |
|
Event Counts: TESTEVENT, Count = 2 |
2918 |
|
Signal Event |
2971 |
|
|
2972 |
|
|
2973 |
|
|
2974 |
– |
|
2974 |
|
Local Backup Complete |
2975 |
|
|
2976 |
|
Local Restore |
4668 |
|
Raw Value = 999912345678 Scale = -8 |
4669 |
|
Value from Raw Data = 9999123.456780 |
4670 |
|
Raw Value = 9999123456780 Scale = -6 |
4671 |
+ |
Numeric Operations |
4672 |
+ |
Add 2.23 + 24.12345 = 26.35345 |
4673 |
+ |
Add Double 2.23 + 24.12645 = 26.35645 |
4674 |
+ |
Add integer 2.23 + 2412345 = 2412347.23 |
4675 |
+ |
Subtract 2.23 - 24.12345 = -21.89345 |
4676 |
+ |
Subtract Double 24.12645 - 2.23 = -21.89645 |
4677 |
+ |
Subtract integer 24123.45 - 223 = -23900.45 |
4678 |
+ |
Multiply 2.23 * 24.12345 = 53.7952935 |
4679 |
+ |
Multiply Double 24.12645 * 2.23 = 53.8019835 |
4680 |
+ |
Multiply integer 241.2345 * 223 = 53795.2935 |
4681 |
+ |
Divide 24.12345 / 2.23 = 10.81769 |
4682 |
+ |
Divide Double 2.23 / 24.12645 = 0.09 |
4683 |
+ |
Divide integer 241.2345 / 223 = 1.0818 |
4684 |
+ |
Compare 2.23, -24.12345 = 1 |
4685 |
+ |
Compare integer 2.23, 3 = -1 |
4686 |
+ |
Compare Double 2.23, 2.23 = 0 |
4687 |
+ |
Negate 24.12345 = -24.12345 |
4688 |
|
SQL Params |
4689 |
|
SQLType =SQL_LONG |
4690 |
|
sub type = 0 |
4942 |
|
IBX$TRANSACTIONID = 8 |
4943 |
|
IBX$OLDTRANSACTIONID = NULL |
4944 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4945 |
< |
IBX$CREATED = 2022/01/09 15:24:09.1790 |
4945 |
> |
IBX$CREATED = 2022/01/14 22:58:12.7560 |
4946 |
|
IBX$SESSIONID = 1 |
4947 |
|
IBX$TRANSACTIONID = 10 |
4948 |
|
IBX$OLDTRANSACTIONID = 9 |
4949 |
|
IBX$USER = SYSDBA (Charset Id = 4 Codepage = 65001) |
4950 |
< |
IBX$CREATED = 2022/01/09 15:24:09.5040 |
4950 |
> |
IBX$CREATED = 2022/01/14 22:58:13.0520 |
4951 |
|
|
4952 |
|
Journal Entries |
4953 |
|
Journal Entry = jeTransStart(Transaction Start) |