help on tpch benchmark

Started by Luis Alberto Amigo Navarroalmost 24 years ago1 messages
#1Luis Alberto Amigo Navarro
lamigo@atc.unican.es
9 attachment(s)

hi all.
We have done a like tpch benchmark and we would like to have some performance tips.
the benchmark is based on this database:

we are creating indexes on indeices.sql

There are 22 ad-hoc queries running on diferent streams while there are concurrent insertions and deletes, numeric are part of the specifications.
Are there any tips?

thanks in advance

Attachments:

orders.sqlapplication/octet-stream; name=orders.sqlDownload
customer.sqlapplication/octet-stream; name=customer.sqlDownload
lineitem.sqlapplication/octet-stream; name=lineitem.sqlDownload
nation.sqlapplication/octet-stream; name=nation.sqlDownload
supplier.sqlapplication/octet-stream; name=supplier.sqlDownload
part.sqlapplication/octet-stream; name=part.sqlDownload
partsupp.sqlapplication/octet-stream; name=partsupp.sqlDownload
region.sqlapplication/octet-stream; name=region.sqlDownload
indices.sqlapplication/octet-stream; name=indices.sqlDownload