Hey - I have a CF caching question - I have a tabl...
# cfml-generala
Anders Lars
09/27/2022, 2:25 PMHey - I have a CF caching question - I have a table with 500k records in MS SQL, each of which has an ID (int) and 2 other identifiers that are both 6 -20 character varchar strings. Different components in the app are constantly converting between these IDs for different purposes - maybe 5 - 20 times/second. FWIW there are multiple server nodes in the cluster.
The lookups from SQL are fast, but wondering if there is anything in the CF/Lucee caching arsenal that is an obvious fit for this - or if it's just too large of a dataset to bother caching.
z
zackster
09/27/2022, 2:30 PMfirst question of performance, how long does this 5-20 times a second take? 5ms, i wouldn't bother?
a
Anders Lars
09/27/2022, 2:36 PMok thanks. yes <5ms on average
z
zackster
09/27/2022, 3:44 PMin cfml stuff gets constantly cast, or checked if it can be cast
e
Evil Ware
09/28/2022, 5:36 PMKind of slow, depending on your dataset. In MS SQL you can run this, where network packet size should be the size of your maximum TCP Packet window supported by your hardware card and network infrastructure. IE if you have a 10GB backbone or better this could work for you.
EXEC sp_configure 'show advanced options,
GO
RECONFIGURE ;
GO
EXEC sp_configure 'network packet size', 8000 ;
GO
RECONFIGURE;
GO