-
Notifications
You must be signed in to change notification settings - Fork 2
/
ChangeLog
1762 lines (1169 loc) · 51.8 KB
/
ChangeLog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
2009-06-11 13:28
Release v3.0.0
Improvement:
============
・libpqを使用した測定が実施できるように変更した。
- これに伴い、configureのオプションを変更した。
・シーケンス番号を自動的に変更してシーケンスを作成するスクリプトを追加した。
- scripts/pgsql/create_sequence.sh
・odbcのAUTOCOMMIT属性の設定順序を変更することで以下の新odbcバージョンに対応した。
- psqlodbc-08.03.0400 / libiodbc-3.52.6
・マルチクライアント測定用の簡易実行ツールを作成した。
- wrapper/*
bug fixes:
============
・非マルチスレッドセーフ関数をマルチスレッドセーフに対応するよう修正した。
200y-mm-dd hh:mi
Release v2.3
Improvement:
============
・使用するデータ型を以下のように変更した。
- SQL_C_LONG → SQL_C_SBIGINT
- SQL_C_ULONG → SQL_C_UBIGINT
- SQL_INTEGER → SQL_C_SHORT
・ol_idを1からの通番に変更した。（interfaces/odbc_com/interaction_buy_confirm.c）
bug fixes:
============
・在庫量の更新計算ミスを修正した。
・c_passwdに小文字化したc_unameを使用するように変更した。（include/inc_pgsql/InsertCust.h）
・STMT_InsertCust_LastCIDのSQLを実行しないように修正した。（include/inc_pgsql/InsertCust.h）
・文字列変数の長さが不足していた問題を修正した。（interfaces/odbc_com/addToSC.c, createSC.c）
・memset()による初期化漏れを修正した。（interfaces/odbc_com/createSC.c）
・不必要な箇所でのCOMMITを削除した。（interfaces/odbc_com/interaction_admin_confirm.c）
・該当レコードが 0 のときの処理を追加。（interfaces/odbc_com/addToSC.c）
・STMT_BUYCONF_getCountryの呼び出し部分のコメントアウトを解除した。（interfaces/odbc_com/interaction_buy_confirm.c）
・c_idが未定の場合の処理を追加した。（interfaces/odbc_com/interaction_home.c）
・STMT_ORDER_DISPLAY_selODRInfoの結果が0件のときの処理を削除した。（interfaces/odbc_com/interaction_order_display.c）
・ループ回数の計算ミスを修正した。（interfaces/odbc_com/interaction_shopping_cart.c）
・createSC()呼び出し箇所を変更した。（interfaces/odbc_com/interaction_shopping_cart.c）
200y-mm-dd hh:mi
Release v2.1.1
Improvement:
============
・co_id変数をint型からshort型に変更した。
・テーブルカラムのnumeric型を下記の対応する型にそれぞれ変更した。
- small int、int、bigint
・COPYによるデータロード前に、TRUNCATEを実施するように変更した。
・データロード後に主キーを作成するように変更した。
・DBT1で使用するリレーションにPUBLIC権限を付与していた箇所を削除した。
・外部キーをすべて削除した。
2003-02-03 14:48 jztpcw
* doc/sapdb_dbt1_sizing.sxc: added sheet 'data file size'
2003-02-03 14:46 jztpcw
* doc/osdl-dbt1-user-manual.sxw: reformatted by Dave on Sep/11/02,
rewrote the instructions 'how to compile' to use autoconfig, added
more detail explanation for build_db.sh and the scripts in
/scripts/sapdb
2003-02-03 14:44 jztpcw
* doc/: osdl-dbt1-architecture.sxw, osdl-dbt1-maintenance.sxw,
osdl-dbt1-tpc.sxw: reformatted by Dave on Sep/11/02
2003-01-28 14:44 fimath
* common/common.c: Removed a superfluous printf().
2003-01-28 13:29 fimath
* cache/cache.c: Fixed a bug where the return from undo_digsyl()
had to be decremented to be able to index the arrays with the
search data correctly.
2003-01-28 11:49 fimath
* cache/cache.c: Destroy the mutex_counter after warm up, since
it's not needed anymore.
Forgot to set cache_ready = 1 to let the cache run after warm up.
2003-01-27 15:53 fimath
* cache/cache.c: Used pthread_join() to wait for threads to finish,
instead of semaphore.
Made the cache start its listener before initializing the database
connections.
Fixed the logic for dividing up the work when the cache is warmed
up.
Re-added the logic to parallelize the work to warm up the cache.
Added the option to define the path to write output files.
Defined a sanity check option (-s) to output the entire contents of
the cache when it warms up, and how the division of labor is done
for the parallelized warm up.
Cache requests are not serviced until the cache is warm.
Added various output messages to display the cache progress in
warming up.
Applied a consistent style in various parts of the code.
2003-01-27 15:48 fimath
* include/cache.h: Added a copyright statement. Changed the ifndef
to match the filename. Removed function prototypes for functions
that are only used locally.
2003-01-27 15:47 fimath
* common/common.c: Added code to support defining an output
directory, if so desired.
2003-01-27 15:46 fimath
* include/common.h: Defined extern output_path to support the
option of defining an output directory for all programs.
2003-01-24 13:59 jztpcw
* scripts/sapdb/restore_db.sh: added db_cold before changing
parameter DATA_CACHE
2003-01-24 13:49 jztpcw
* scripts/sapdb/backup_db.sh: added db_cold before changing
parameter DATA_CACHE
2003-01-24 13:48 jztpcw
* scripts/sapdb/set_param.sh: added db_cold before changing
parameters
2003-01-24 11:28 jztpcw
* scripts/sapdb/build_db.sh: changed usage message, changed PATH to
DATA_PATH, otherwise system environment variable PATH is screwed up
2003-01-23 15:35 fimath
* cache/cache.c: Reformatting some lines for consistency. Using
optget now. Output some of the cache data after warm up for a
sanity check. Single threaded the cache warm up for correctness.
Using a semaphore, instead of joining with all the threads, to wait
for the warm up to complete.
2003-01-23 15:34 fimath
* storedproc/sapdb/getPromoImages.sql: Was told using WHERE..IN
doesn't guarantee correctness when we're trying to query pairs.
Using a slow, but correct method for now.
2003-01-23 15:20 fimath
* interfaces/odbc/odbc_interaction_search_results.c: The assignment
of i_related and i_thumbnail variables were in the wrong order.
2003-01-21 13:32 fimath
* datagen/main.c: By default, don't create the data files in
parallel, it slows down for some reason.
2003-01-17 17:31 fimath
* scripts/sapdb/: drop_dbproc.sh, drop_dbproc.sql: Moved
drop_dbproc.sql into drop_dbprod.sh and updated the list of stored
procedures to be dropped.
2003-01-17 17:16 jztpcw
* scripts/sapdb/build_db.sh: moved update statistics before
load_dbproc
2003-01-16 17:03 fimath
* make.common.in: Removed -lsqlod because autoconf puts it in there
for us.
2003-01-16 14:34 jztpcw
* scripts/sapdb/: backup_db.sh, restore_db.sh: move bouncing
database at the end to set_param.sh
2003-01-16 14:34 jztpcw
* scripts/sapdb/set_param.sh: add bouncing database at the end if
it is called using parameter 1
2003-01-16 12:48 jztpcw
* scripts/sapdb/define_medium.sh: correct SID to SID1
2003-01-16 10:12 fimath
* appServer/appServer.c, appServer/app_interface.c,
appServer/app_threadpool.c, appServer/app_txn_array.c,
cache/cache.c, cache/cache_interface.c, common/common.c,
dbdriver/eu.c, dbdriver/tm_interface.c, include/common.h,
interfaces/odbc/odbc_interaction.c,
interfaces/odbc/odbc_interaction_admin_confirm.c,
interfaces/odbc/odbc_interaction_admin_request.c,
interfaces/odbc/odbc_interaction_best_sellers.c,
interfaces/odbc/odbc_interaction_buy_confirm.c,
interfaces/odbc/odbc_interaction_buy_request.c,
interfaces/odbc/odbc_interaction_home.c,
interfaces/odbc/odbc_interaction_new_products.c,
interfaces/odbc/odbc_interaction_order_display.c,
interfaces/odbc/odbc_interaction_order_inquiry.c,
interfaces/odbc/odbc_interaction_product_detail.c,
interfaces/odbc/odbc_interaction_search_request.c,
interfaces/odbc/odbc_interaction_search_results.c,
interfaces/odbc/odbc_interaction_shopping_cart.c: Changed W_OK to
OK to avoid conflicts with unistd.h.
2003-01-16 10:11 fimath
* make.common.in: Left out -lsqlod.
2003-01-16 09:01 jztpcw
* scripts/sapdb/: add_aux_structure.sql, add_aux_structure.sh:
correct a typo
2003-01-15 15:34 jztpcw
* scripts/sapdb/update_stats.sh: use instead of hard coding DBT1
2003-01-15 15:33 jztpcw
* scripts/sapdb/restore_db.sh: added calling define_mediium and
set_param
2003-01-15 15:30 jztpcw
* scripts/sapdb/: load_db.sh, restart.sh: use instead of hard
coding DBT1
2003-01-15 15:29 jztpcw
* scripts/sapdb/drop_dbproc.sh: this script is not called by any
other script, but is useful
2003-01-15 15:27 jztpcw
* scripts/sapdb/: create_indexes.sh, create_tables.sh, drop_db.sh,
drop_tables.sh, load_dbproc.sh: use instead of hard coding DBT1
2003-01-15 15:24 fimath
* appServer/appServer.c, appServer/app_interface.c,
appServer/app_txn_queue.c, dbdriver/main.c: Repressed compiler
warnings.
2003-01-15 15:22 jztpcw
* scripts/sapdb/drop_dbproc.sql: changed dbproc name
buyrequest->buy_request buyconfirm->buy_confirm
shoppingcart->shopping_cart
2003-01-15 15:21 fimath
* Makefile.in, configure, configure.in, make.common.in,
appServer/Makefile.in, cache/Makefile.in, dbdriver/Makefile.in,
interfaces/odbc/Makefile.in, tools/Makefile.in: Fixed various
inconsistencies in the Makefiles. Adapted it so the odbc include
and library paths much be set in the environment before configure
is run.
2003-01-15 15:19 jztpcw
* scripts/sapdb/create_tables.sql: removed foreign key definition
2003-01-15 15:19 jztpcw
* scripts/sapdb/create_indexes.sql: removed not used indexes
2003-01-15 15:11 jztpcw
* scripts/sapdb/: create_fk.sh, create_fk.sql: move the foreign key
definition from create_tables to separate files, and create foreign
keys after loading the tables
2003-01-15 15:05 jztpcw
* scripts/sapdb/create_db.sh: added parameter 0 when calling
set_param.sh
2003-01-15 15:03 jztpcw
* scripts/sapdb/build_db.sh: removed foreign key definition from
create_table, backup_db after loading the table so that it is not
read only, create foreign key, and backup again at the end. This is
faster especially for large db
2003-01-15 15:02 fimath
* dbdriver/Makefile.in: Stop building phase 1 driver (since I can't
figure out why it won't build.)
2003-01-15 14:55 jztpcw
* scripts/sapdb/backup_db.sh: call define_medium.sh and
set_param.sh
2003-01-15 14:51 jztpcw
* scripts/sapdb/define_medium.sh: define backup medium
2003-01-15 14:50 jztpcw
* scripts/sapdb/add_aux_structure.sql: create prejoined tables for
large scale database
2003-01-15 14:46 fimath
* dbdriver/tm_interface.c: Initialized variables to suppress
compiler warnings.
2003-01-15 14:27 jztpcw
* interfaces/odbc/: odbc_interaction_admin_confirm.c,
odbc_interaction_admin_request.c, odbc_interaction_best_sellers.c,
odbc_interaction_buy_confirm.c, odbc_interaction_buy_request.c,
odbc_interaction_home.c, odbc_interaction_new_products.c,
odbc_interaction_order_display.c, odbc_interaction_order_inquiry.c,
odbc_interaction_search_request.c,
odbc_interaction_search_results.c,
odbc_interaction_shopping_cart.c: used SQLEndTran instead of
calling COMMIT statement, I do not know what the exact difference
but this seems to be the offical way of ending a transaction
2003-01-15 14:11 fimath
* common/_socket.c: Initialize sockfd to avoid a compiler warning.
2003-01-15 13:20 jztpcw
* interfaces/odbc/: odbc_interaction_home.c,
odbc_interaction_new_products.c, odbc_interaction_order_display.c:
added COMMIT, I did not commit for read-only transactions
2003-01-15 13:16 jztpcw
* interfaces/odbc/: odbc_interaction_admin_request.c,
odbc_interaction_best_sellers.c: added COMMIT, I did not commit for
read-only transactions
2003-01-15 13:09 fimath
* tools/results.c: Fixed some style inconsistencies. Implemented
getopt().
2003-01-15 10:54 jztpcw
* scripts/stats/get_xcons.sh: script to get SAPDB xcons output
2003-01-15 10:52 jztpcw
* scripts/stats/get_log_info.sh: script to get log info
2003-01-15 10:49 fimath
* tools/results.c: Added headers, type casts, and removed unused
variables.
2003-01-15 10:48 fimath
* tools/Makefile.in: Now using CFLAGS for all objects.
2003-01-15 10:44 jztpcw
* scripts/stats/db_stats.sh: scripts to collect database statistics
2003-01-15 10:43 jztpcw
* scripts/stats/collect_data.sh: added calling db_stats.sh
2003-01-15 10:35 fimath
* tools/: Makefile.in, results.c: Consolidate use of
interaction_short_name[] into common.c and improved the readability
of the output of results.c.
2003-01-15 10:34 fimath
* appServer/appServer.c, common/common.c, dbdriver/eu.c,
include/common.h: Consolidated the use of intereaction_short_name[]
into common.c.
2003-01-15 10:14 fimath
* datagen/: Makefile.in, main.c: Multi-threaded the data generation
and simplified some login.
2003-01-15 10:03 fimath
* datagen/filelist.txt: Updated.
2003-01-15 09:37 fimath
* datagen/Makefile.in, datagen/address.c, datagen/author.c,
datagen/customer.c, datagen/item.c, datagen/main.c,
datagen/orders.c, include/datagen.h: datagen.h was really poorly
implemented, so I removed it, combined all the .c files into main.c
and fixed the Makefile.in to reflect the changes.
2003-01-15 09:25 fimath
* include/datagen.h: Removed function prototypes that don't need to
be advertised to other files.
2003-01-15 09:20 fimath
* datagen/main.c: Fixed more formatting inconsistencies.
2003-01-15 09:18 fimath
* datagen/main.c: Normalized comments and various formatting
inconsistencies.
2003-01-14 17:00 fimath
* datagen/item.c: Added type casts to prevent compiler warnings.
2003-01-14 17:00 fimath
* datagen/customer.c: Added header files and type casts to prevent
compiler warnings. Used fclose() instead of close to close the
file.
2003-01-14 16:59 fimath
* datagen/address.c: Fixed a typo for declaring
_LARGEFILE64_SOURCE.
2003-01-14 16:54 fimath
* common/_socket.c: Added header files and removed unused variables
to prevent compiler warnings.
2003-01-14 16:51 fimath
* dbdriver/main.c: Added header files and moved variables under the
appropriate #ifdef declarations to prevent compiler warnings.
2003-01-14 16:50 fimath
* dbdriver/eu.c: Added header files, added type casts, fixed return
values, and removed unused variables to prevent compiler warnings.
Corrected the execute_search_request() call for PHASE1 builds.
Removed the use of the retry variable that was being printed to
mix.log.
2003-01-14 16:48 fimath
* dbdriver/Makefile.in: Removed various output files with a 'make
clean'.
2003-01-14 16:47 fimath
* include/common.h: Fixed a typo in a function prototype.
2003-01-14 16:23 fimath
* appServer/app_txn_array.c: Added header files and a return value
to prevent compiler warnings.
2003-01-14 16:22 fimath
* appServer/app_threadpool.c: Added headers files and removed
unused variables to prevent compiler warnings.
2003-01-14 16:22 fimath
* appServer/appServer.c: Added a header file to prevent compiler
warnings and removed unused variables.
2003-01-14 16:21 fimath
* include/odbc_interaction.h: Added a header file to prevent
compiler warnings.
2003-01-14 16:07 fimath
* cache/cache_interface.c: Removed an unused variable.
2003-01-14 16:06 fimath
* cache/cache.c: Added header files, removed unused variables to
repress compiler warnings. Fixed assignment problems with if..else
statements.
2003-01-14 15:56 fimath
* tools/odbc_test.c: Added header files, fixed a return value, and
added type casts to stop compiler warnings.
2003-01-14 15:54 fimath
* tools/Makefile.in: Remove .log files generated on a 'make clean'.
2003-01-14 15:52 fimath
* interfaces/odbc/odbc_interaction_shopping_cart.c: Fixed a comment
to avoid a compiler warning.
2003-01-14 15:51 fimath
* interfaces/odbc/odbc_interaction_order_inquiry.c: Removed unused
variables.
2003-01-14 15:50 fimath
* interfaces/odbc/: odbc_interaction_admin_confirm.c,
odbc_interaction_admin_request.c,
odbc_interaction_product_detail.c: Removed an unused variable.
2003-01-14 15:36 fimath
* datagen/main.c: Fixed some printf()'s and added a prototype to
suppress compiler warnings.
2003-01-14 15:29 fimath
* datagen/orders.c: Added type casts to repress compiler warnings.
2003-01-14 15:26 fimath
* common/common.c: Added string.h and a typecast to quit compiler
warnings.
2003-01-14 14:54 fimath
* Makefile.in, configure, configure.in, make.common.in: Used
autoconf to genearte makefiles.
2003-01-14 14:48 fimath
* Makefile, common.mk: Used autoconf to genearte makefiles.
2003-01-14 14:34 fimath
* appServer/Makefile, appServer/Makefile.in, cache/Makefile,
cache/Makefile.in, common/Makefile, common/Makefile.in,
datagen/Makefile, datagen/Makefile.in, dbdriver/Makefile,
dbdriver/Makefile.in, interfaces/odbc/Makefile,
interfaces/odbc/Makefile.in, tools/Makefile, tools/Makefile.in,
wgen/Makefile, wgen/Makefile.in: Used autoconf to genearte
makefiles.
2003-01-02 10:52 jztpcw
* scripts/sapdb/restore_db.sh: use instead of DBT1
2003-01-02 10:51 jztpcw
* scripts/sapdb/create_db.sh: changed DBT3 to , moved parameter
setting to set_param.sh
2003-01-02 10:47 jztpcw
* scripts/sapdb/set_param.sh: set database parameters
2003-01-02 10:22 jztpcw
* scripts/sapdb/backup_db.sh: moved medium definition from
create_db.sh to backup_db.sh
2003-01-02 10:13 jztpcw
* doc/sapdb_dbt1_sizing.sxc: spreadsheet for calculating sapdb size
for dbt1
2003-01-02 10:11 jztpcw
* doc/sapdb_sizing.sxc: renamed
2003-01-02 09:33 jztpcw
* include/odbc_interaction.h: added include <WINDOWS.H> and a
comment about this line
2002-12-27 17:06 jztpcw
* include/odbc_interaction.h: added AUTOCOMMIT_OFF
2002-12-27 17:04 jztpcw
* storedproc/sapdb/shoppingcart.sql: renamed to shopping_cart.sql
2002-12-27 17:03 jztpcw
* storedproc/sapdb/buyconfirm.sql: renamed to buy_confirm.sql
2002-12-27 17:03 jztpcw
* storedproc/sapdb/buyrequest.sql: renamed to buy_request.sql
2002-12-27 16:59 jztpcw
* storedproc/sapdb/: addToSC.sql, getCustInfo.sql, updateSC.sql,
order_display.sql: rewrote the queries to skip temp variables
2002-12-27 16:55 jztpcw
* storedproc/sapdb/shopping_cart.sql: renamed from shoppingcart.sql
2002-12-27 16:54 jztpcw
* storedproc/sapdb/buy_request.sql: renamed from buyquest
2002-12-27 16:53 jztpcw
* storedproc/sapdb/buy_confirm.sql: renamed from buyconfirm
2002-12-27 16:51 jztpcw
* storedproc/sapdb/best_sellers_new.sql: use the cursor to
implement real best_sellers, but have to drop it due to
performance. check in for furture use
2002-12-27 16:49 jztpcw
* include/odbc_interaction_shopping_cart.h: renamed dbproc name to
shopping_cart
2002-12-27 16:48 jztpcw
* include/odbc_interaction_buy_confirm.h: renamed dbproc name to
buy_confirm
2002-12-27 16:48 jztpcw
* include/odbc_interaction_buy_request.h: renamed dbproc name to
buy_request
2002-12-27 16:41 jztpcw
* interfaces/odbc/: odbc_interaction.c,
odbc_interaction_admin_confirm.c, odbc_interaction_buy_confirm.c,
odbc_interaction_buy_request.c, odbc_interaction_shopping_cart.c:
added AUTOCOMMIT_OFF
2002-12-06 10:03 jztpcw
* scripts/sapdb/restore_db.sh: renamed recover_db.sh to
restore_db.sh
2002-12-06 09:59 jztpcw
* scripts/sapdb/recover_db.sh: change the name to restore_db.sh
2002-12-04 11:07 jztpcw
* scripts/sapdb/create_db.sh: added medium incr definition
2002-12-04 11:05 jztpcw
* scripts/sapdb/recover_db.sh: added incremental recover
2002-12-04 11:05 jztpcw
* scripts/sapdb/backup_db.sh: added incremental backup
2002-12-04 11:03 jztpcw
* scripts/sapdb/build_db.sh: changed the script to use the new
datagen
2002-11-25 09:20 jztpcw
* datagen/Makefile: added -DSTDLIB_HAS_GETOPT
2002-11-19 10:51 jztpcw
* include/datagen.h: added usage and process_option function
definition
2002-11-19 10:50 jztpcw
* datagen/main.c: added more command line options so that
individual data can be generated
2002-11-14 09:29 jztpcw
* include/datagen.h: changed function definition to accept path of
the flat file
2002-11-14 09:29 jztpcw
* datagen/main.c: added the third parameter <path>
2002-11-14 09:25 jztpcw
* datagen/orders.c: changed function definition to accept path of
the flat file
2002-11-14 09:22 jztpcw
* datagen/: customer.c, item.c: changed function definition to
accept path of the flat file
2002-11-14 08:59 jztpcw
* datagen/author.c: changed function definition to accept path of
the flat file
2002-11-14 08:45 jztpcw
* datagen/address.c: changed function definition to accept path of
the flat file
2002-11-07 11:13 jztpcw
* scripts/sapdb/load_db.sh: rearrange the order in which the tables
are loaded so that it will pass the foreign key check
2002-10-25 17:00 jztpcw
* dbdriver/Makefile, tools/Makefile: rearranged so that it would be
easier to switch the odbc files.
2002-10-25 16:53 jztpcw
* cache/Makefile: rearranged so that it would be easier to switch
the odbc files.
2002-10-25 16:33 jztpcw
* appServer/Makefile: rearranged so that it would be easier to
switch the odbc files.
2002-10-25 16:20 jztpcw
* common.mk: rearranged so that it would be easier to switch the
odbc files. For example, to switch from sapdbodbc to unixodbc,
modify ODBC_INCL and ODBC_LIB, remove '#include <WINDOWS.H> in
include/odbc_interactions.h'
2002-10-25 14:19 jztpcw
* tools/results.c: added initializing previous_time
2002-10-25 14:16 jztpcw
* scripts/stats/collect_data.sh: added collecting more database
monitor data
2002-10-25 14:11 jztpcw
* scripts/sapdb/: create_keys.sh, create_keys.sql: moved FK
definition to create_tables.sql
2002-10-25 14:09 jztpcw
* scripts/sapdb/create_indexes.sql: removed some of the indexes
because they are the primary keys
2002-10-25 14:08 jztpcw
* scripts/sapdb/create_tables.sql: added primary key and foreign
key definition
2002-10-25 14:05 jztpcw
* scripts/sapdb/build_db.sh: removed create_keys and create
sequences
2002-10-15 17:18 jztpcw
* scripts/sapdb/build_db.sh: fixed some bugs
2002-10-04 15:19 jztpcw
* storedproc/sapdb/best_sellers.sql: the old best_sellers
2002-10-04 15:18 jztpcw
* storedproc/sapdb/best_sellers.sql: this one is more close to tpcw
best_sellers but it takes the database > min to get the results
2002-10-04 15:11 jztpcw
* ChangeLog, cache/Makefile, doc/sapdb_sizing.sxc,
storedproc/sapdb/best_sellers.sql: ChangeLog
2002-10-03 16:22 jztpcw
* tools/results.c: changed checking fscanf return value so that
results can handle the mix.log with/without START mark
2002-10-03 15:23 jztpcw
* storedproc/sapdb/DigSyl.sql: added copy right info
2002-10-03 15:22 jztpcw
* storedproc/sapdb/buyconfirm.sql: remove subtrans; instead of
using the expression (:i_stock-:scl_qty+21) in the update, evaluate
the expression first to work around SAPDB bug
2002-10-03 14:49 jztpcw
* storedproc/sapdb/shoppingcart.sql: call updateSCSubtotal if
shopping_cart_line is changed. Do not call addToSC if sc_id is
known and add_flag=0 and itemcount=0 to reduce access to item table
2002-10-02 13:38 jztpcw
* storedproc/sapdb/DigSyl.sql: fixed 1 bug: changed
SUBSTR('BAOGALRIRESEATILINNG' to SUBSTR('BAOGALRIRESEATULINNG'
2002-10-02 13:34 jztpcw
* storedproc/sapdb/updateSC.sql: remove subtrans; instead of using
the expression (:i_stock-:scl_qty+21) in the update, evaluate the
expression first to work around SAPDB bug
2002-10-02 13:29 jztpcw
* storedproc/sapdb/addToSC.sql: removed subtrans;changed stop to
return; fixed 1 bug by moving updateSCSubtotal to shopping_cart.sql
2002-10-02 11:15 jztpcw
* dbdriver/eu.c: fixed 2 bugs in prepare_shopping_cart:added
euc->shopping_cart_data.sc_size = 0 if customer visit
shopping_cart; fixed generating refresh list for shopping cart
2002-09-06 14:26 jztpcw
* scripts/sapdb/build_db.sh: fixed a bug which stops building db
after generating data files if -g is used
2002-09-06 09:19 jztpcw
* doc/user.sxw: revised to reflect the current state of the kit:
added how to run with multiple drivers and appServers, usage of
several new scripts, and guideline of getting consistent results
2002-09-06 09:14 jztpcw
* doc/: architecture.sxw, maintenance.sxw, tpc.sxw: added osdl and
copyright label
2002-08-28 14:15 jztpcw
* scripts/stats/analyze_BT.sh: the script to cat multiple dbdriver
mix.log and run results on it
2002-08-28 14:12 jztpcw
* scripts/stats/dbdriver.config: a sample dbdriver configuraton
file
2002-08-28 13:49 jztpcw
* scripts/stats/run_dbt1.sh: uncomment rm /tmp/*.log
2002-08-28 13:31 jztpcw
* scripts/sapdb/db_setup_sample.sh: this file is replace by
build_db.sh
2002-08-28 13:30 jztpcw
* scripts/sapdb/monitor.sh: redirect monitor data to different
files
2002-08-28 13:29 jztpcw
* scripts/sapdb/build_db.sh: now accept command line argument '-g'
to generate datafile before loading the database
2002-08-28 13:26 jztpcw
* scripts/run_test_sample.sh: this file is replaced by
stats/run_dbt1.sh
2002-08-28 13:25 jztpcw
* scripts/stats/dbt1.config: a sample dbt1 run config file which is
read by run_dbt1.sh
2002-08-28 13:23 jztpcw
* scripts/stats/run_dbt1.sh: a script to start the dbt1 run,
collect data and analyze results
2002-08-28 13:20 jztpcw
* scripts/stats/collect_data.sh: added command line parameter check
2002-08-28 13:12 jztpcw
* tools/results.c: removed reading START mark since it is handled
by a script, exclude failed interaction from total_interaction
count
2002-08-28 13:07 jztpcw
* dbdriver/main.c: removed generating END mark to mix.log
2002-08-28 13:05 jztpcw
* dbdriver/eu.c: in struct eu_context_t, added a flag
first_interaction to make 'prepare_home' generate new c_id only for
first interaction of a user session, set sc_id to
UNKNOWN_SHOPPING_CART after buy_confirm
2002-08-28 13:03 jztpcw
* include/eu.h: in struct eu_context_t, added a flag
first_interaction to make 'prepare_home' generate new c_id only for
first interaction of a user session
2002-08-20 13:13 fimath
* tools/results.c: Fixed some mispellings in variable names. Fixed
the calculation of elapsed time for the ips.csv file.
2002-08-20 11:08 olmsteab
* datagen/: address.c, author.c, customer.c, item.c, main.c,
orders.c: updated the files to use fopen64 instead of fopen so that
data files greater than 2GB could be created.
2002-08-16 10:23 jztpcw
* appServer/appServer.c: changed the message to 'The server is
active...'
2002-08-16 10:21 jztpcw
* cache/cache.c: added signal handle for SIGSEGV to catch memory
violation
2002-08-15 14:31 jztpcw
* appServer/appServer.c: change perror to printf so that the STP
script can catch it
2002-08-15 13:53 jztpcw
* cache/cache.c: change perror to printf so that the STP script can
catch it
2002-08-15 12:18 jztpcw
* appServer/appServer.c: set stdout buffer to line buffer so that
the output is flushed to file line by line
2002-08-15 12:17 jztpcw
* cache/cache.c: use setlinebuf instead of setvbuf
2002-08-15 10:12 jztpcw
* cache/cache.c: set stdout buffer to line buffer so that the
output is flushed to file line by line
2002-08-05 09:22 fimath
* dbdriver/eu.c, dbdriver/main.c, include/common.h, include/eu.h,
tools/results.c: Incorporated changes to mark the begining and end
time of the run in the log files and made the appropriate changes
in the results calculations.
2002-08-02 09:21 jztpcw
* scripts/sapdb/build_db.sh: scripts to build database
2002-08-02 09:20 jztpcw
* scripts/sapdb/recover_db.sh: script to restore database
2002-07-30 10:33 jztpcw
* filelist.txt: added cache directory
2002-07-30 10:29 jztpcw
* CVSROOT/loginfo: configured login to call syncmail when
committing changes
2002-07-30 10:26 jztpcw
* scripts/stats/collect_data.sh: added description at the beginning
of mcache* files
2002-07-30 10:18 jztpcw