2017-07-13 00:06:46 +03:00
|
|
|
module Main where
|
|
|
|
|
|
|
|
import Data.ByteString.Lazy (toStrict)
|
|
|
|
import Data.ByteString.Builder (toLazyByteString)
|
|
|
|
import Data.ByteString (ByteString)
|
|
|
|
import Data.Monoid
|
2017-07-13 02:10:24 +03:00
|
|
|
import Data.Foldable
|
2017-07-13 00:06:46 +03:00
|
|
|
import System.IO.Unsafe
|
|
|
|
import Criterion.Main
|
|
|
|
import Data.Time
|
|
|
|
import Data.UUID
|
|
|
|
import Data.UUID.V4 (nextRandom)
|
|
|
|
import Data.Scientific
|
2017-07-13 02:10:24 +03:00
|
|
|
import Data.Vector (Vector)
|
|
|
|
import qualified Data.ByteString as B
|
2017-07-13 00:06:46 +03:00
|
|
|
|
|
|
|
import Database.PostgreSQL.Protocol.Types
|
|
|
|
import Database.PostgreSQL.Protocol.Encoders
|
|
|
|
import Database.PostgreSQL.Protocol.Store.Encode
|
|
|
|
import Database.PostgreSQL.Protocol.Store.Decode
|
2017-07-13 02:10:24 +03:00
|
|
|
import Database.PostgreSQL.Protocol.DataRows
|
2017-07-13 00:06:46 +03:00
|
|
|
import qualified Database.PostgreSQL.Protocol.Codecs.Decoders as PD
|
|
|
|
import qualified Database.PostgreSQL.Protocol.Codecs.Encoders as PE
|
|
|
|
import qualified Database.PostgreSQL.Protocol.Codecs.PgTypes as PGT
|
|
|
|
|
|
|
|
main :: IO ()
|
|
|
|
main = defaultMain
|
|
|
|
[ bgroup "Encoding"
|
|
|
|
[ bench "Message" $ nf encodeMessage queryParams
|
|
|
|
, bench "Scientific" $ nf (runEncode . PE.numeric) testScientific
|
|
|
|
, bench "UTCTime" $ nf (runEncode . PE.timestamptz) testUTCTime
|
|
|
|
, bench "UUID" $ nf (runEncode . PE.uuid) testUUID
|
2017-07-13 02:10:24 +03:00
|
|
|
]
|
|
|
|
, bgroup "Decoding"
|
|
|
|
[ bench "Message" $ nf decodeMessage testDataRows
|
|
|
|
, bench "Message as bytes" $ nf decodeMessageBytes testDataRows
|
|
|
|
, bench "Scientific" $ nf (runDecode $ PD.numeric 0) testScientificEncoded
|
|
|
|
, bench "UTCTime" $ nf (runDecode $ PD.timestamptz 0) testUTCTimeEncoded
|
|
|
|
, bench "UUID" $ nf (runDecode $ PD.uuid 0) testUUIDEncoded
|
|
|
|
]
|
2017-07-13 00:06:46 +03:00
|
|
|
]
|
|
|
|
|
|
|
|
type QueryParams
|
|
|
|
= (Bool, ByteString, Double, DiffTime, Scientific, UTCTime, UUID)
|
|
|
|
|
|
|
|
{-# NOINLINE queryParams #-}
|
|
|
|
queryParams :: QueryParams
|
|
|
|
queryParams =
|
|
|
|
( True
|
|
|
|
, "aaaaaaaaaaaa"
|
|
|
|
, 3.1415926
|
|
|
|
, fromIntegral 20000000
|
|
|
|
, scientific 1111111111111 (-18)
|
|
|
|
, unsafePerformIO getCurrentTime
|
|
|
|
, unsafePerformIO nextRandom
|
|
|
|
)
|
|
|
|
|
|
|
|
testScientific :: Scientific
|
|
|
|
testScientific = scientific 11111111111111 (-18)
|
|
|
|
|
2017-07-13 02:10:24 +03:00
|
|
|
testScientificEncoded :: ByteString
|
|
|
|
testScientificEncoded = runEncode $ PE.numeric testScientific
|
|
|
|
|
2017-07-13 00:06:46 +03:00
|
|
|
{-# NOINLINE testUTCTime #-}
|
|
|
|
testUTCTime :: UTCTime
|
|
|
|
testUTCTime = unsafePerformIO getCurrentTime
|
|
|
|
|
2017-07-13 02:10:24 +03:00
|
|
|
testUTCTimeEncoded :: ByteString
|
|
|
|
testUTCTimeEncoded = runEncode $ PE.timestamptz testUTCTime
|
|
|
|
|
2017-07-13 00:06:46 +03:00
|
|
|
{-# NOINLINE testUUID #-}
|
|
|
|
testUUID :: UUID
|
|
|
|
testUUID = unsafePerformIO nextRandom
|
|
|
|
|
2017-07-13 02:10:24 +03:00
|
|
|
testUUIDEncoded :: ByteString
|
|
|
|
testUUIDEncoded = runEncode $ PE.uuid testUUID
|
|
|
|
|
2017-07-13 00:06:46 +03:00
|
|
|
encodeMessage :: QueryParams -> ByteString
|
|
|
|
encodeMessage params = runEncode $
|
|
|
|
encodeClientMessage parseMessage <> encodeClientMessage bindMessage
|
|
|
|
where
|
|
|
|
bindMessage = Bind (PortalName "") stmtName Binary
|
|
|
|
(encodedParams params) Binary
|
2017-07-13 14:38:05 +03:00
|
|
|
encodedParams (a, b, c, d, e, f, g) =
|
2017-07-13 14:57:23 +03:00
|
|
|
[ Just $ PE.bool a
|
|
|
|
, Just $ PE.bytea b
|
|
|
|
, Just $ PE.float8 c
|
|
|
|
, Just $ PE.interval d
|
|
|
|
, Just $ PE.numeric e
|
|
|
|
, Just $ PE.timestamptz f
|
|
|
|
, Just $ PE.uuid g
|
2017-07-13 00:06:46 +03:00
|
|
|
]
|
|
|
|
parseMessage = Parse stmtName stmt oids
|
|
|
|
stmtName = StatementName "_pw_statement_0010"
|
|
|
|
stmt = StatementSQL
|
|
|
|
"SELECT a, b, c FROM table_name WHERE name LIKE $1 AND a > $2"
|
2017-07-13 14:38:05 +03:00
|
|
|
oids = map PGT.oidType
|
2017-07-13 00:06:46 +03:00
|
|
|
[ PGT.bool
|
|
|
|
, PGT.bytea
|
|
|
|
, PGT.float8
|
|
|
|
, PGT.interval
|
|
|
|
, PGT.numeric
|
|
|
|
, PGT.timestamptz
|
|
|
|
, PGT.uuid
|
|
|
|
]
|
|
|
|
|
2017-07-13 02:10:24 +03:00
|
|
|
decodeMessage :: DataRows -> Vector QueryParams
|
|
|
|
decodeMessage = decodeManyRows (PD.dataRowHeader *> decoder)
|
|
|
|
where
|
|
|
|
decoder = (,,,,,,)
|
|
|
|
<$> PD.getNonNullable PD.bool
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.float8
|
|
|
|
<*> PD.getNonNullable PD.interval
|
|
|
|
<*> PD.getNonNullable PD.numeric
|
|
|
|
<*> PD.getNonNullable PD.timestamptz
|
|
|
|
<*> PD.getNonNullable PD.uuid
|
|
|
|
|
|
|
|
decodeMessageBytes
|
|
|
|
:: DataRows
|
|
|
|
-> Vector ( ByteString, ByteString, ByteString, ByteString, ByteString
|
|
|
|
, ByteString, ByteString )
|
|
|
|
decodeMessageBytes = decodeManyRows (PD.dataRowHeader *> decoder)
|
|
|
|
where
|
|
|
|
decoder = (,,,,,,)
|
|
|
|
<$> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
<*> PD.getNonNullable PD.bytea
|
|
|
|
|
|
|
|
{-# NOINLINE testDataRows #-}
|
|
|
|
testDataRows :: DataRows
|
|
|
|
testDataRows = DataRows chunk (DataRows chunk (DataRows chunk Empty))
|
|
|
|
where
|
|
|
|
row = unsafePerformIO $ B.readFile "bench/row.out"
|
|
|
|
rows = fold $ replicate 10 row
|
|
|
|
chunk = DataChunk 10 rows
|