77 |
|
|
78 |
|
------------------------------------------------------ |
79 |
|
Running Test 2: Open the employee database and run a query |
80 |
+ |
Open Database fails Your user name and password are not defined. Ask your database administrator to set up a Firebird login |
81 |
|
Opening inet://localhost/employee |
82 |
|
Database Open, SQL Dialect = 3 |
83 |
|
TPB: Item Count = 3 |
536 |
|
FULL_NAME = Johnson, Leslie |
537 |
|
|
538 |
|
Scollable Cursors |
539 |
+ |
DB Connect String = employee |
540 |
+ |
DB Charset ID = 4 |
541 |
+ |
DB SQL Dialect = 3 |
542 |
+ |
DB Remote Protocol = |
543 |
+ |
DB ODS Major Version = 13 |
544 |
+ |
DB ODS Minor Version = 0 |
545 |
+ |
User Authentication Method = User name in DPB |
546 |
+ |
Firebird Library Path = /opt/firebird4.0.0/lib/libfbclient.so |
547 |
+ |
DB Client Implementation Version = 4.0 |
548 |
|
Do Fetch Next: |
549 |
|
EMP_NO = 2 |
550 |
|
FIRST_NAME = Robert |
656 |
|
SALARY = 64,635.00 |
657 |
|
FULL_NAME = Johnson, Leslie |
658 |
|
|
659 |
< |
Current memory = 19,767,952 |
659 |
> |
Current memory = 19,764,272 |
660 |
|
Delta memory = 4,464 |
661 |
< |
Max memory = 19,813,568 |
662 |
< |
Elapsed time= 0.000 sec |
661 |
> |
Max memory = 19,809,888 |
662 |
> |
Elapsed time= 0.002 sec |
663 |
|
Cpu = 0.000 sec |
664 |
|
Buffers = 2048 |
665 |
|
Reads = 0 |
2697 |
|
|
2698 |
|
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) |
2699 |
|
|
2700 |
< |
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: 14.69) (15: 15.75) (16: 16.79) |
2700 |
> |
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.45) (16: 4269) |
2701 |
|
|
2702 |
|
|
2703 |
|
Shrink to 2:10 |
2713 |
|
|
2714 |
|
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) |
2715 |
|
|
2716 |
< |
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: 14.69) (15: 15.75) (16: 16.79) |
2716 |
> |
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.45) (16: 4269) |
2717 |
|
|
2718 |
|
|
2719 |
|
|
2808 |
|
Version = 1: LI-V6.3.0.2496 Firebird 4.0 |
2809 |
|
Database is Read/Write |
2810 |
|
Database Created: 29/5/2021 16:47:30 |
2811 |
< |
Pages Used = 313 |
2812 |
< |
Pages Free = 762 |
2813 |
< |
Server Memory = 19484112 |
2811 |
> |
Pages Used = 310 |
2812 |
> |
Pages Free = 765 |
2813 |
> |
Server Memory = 19482272 |
2814 |
|
Forced Writes = 1 |
2815 |
< |
Max Memory = 19630384 |
2815 |
> |
Max Memory = 19628544 |
2816 |
|
Num Buffers = 2048 |
2817 |
|
Sweep Interval = 20000 |
2818 |
|
Logged in Users: SYSDBA, |
2819 |
|
Active Transaction Count = 0 |
2820 |
< |
Fetches = 1648 |
2820 |
> |
Fetches = 1641 |
2821 |
|
Writes = 8 |
2822 |
|
Reads = 92 |
2823 |
|
Page Writes = 4 |
2843 |
|
Table ID = 12 |
2844 |
|
Count = 24 |
2845 |
|
Table ID = 18 |
2846 |
< |
Count = 816 |
2846 |
> |
Count = 811 |
2847 |
|
Table ID = 20 |
2848 |
|
Count = 5 |
2849 |
|
Table ID = 28 |
2855 |
|
|
2856 |
|
Sequential Table Scans Operation Counts |
2857 |
|
Table ID = 0 |
2858 |
< |
Count = 100 |
2858 |
> |
Count = 98 |
2859 |
|
Table ID = 1 |
2860 |
|
Count = 24 |
2861 |
|
|
4653 |
|
ITYPE = 1 |
4654 |
|
I64TYPE = 10 |
4655 |
|
CURRTYPE = .02300000 |
4656 |
< |
DTYPE = .00000000 |
4656 |
> |
DTYPE = .00110000 |
4657 |
|
FIXEDPOINT = 233.45600000 |
4658 |
|
|
4659 |
|
|