Perfrmance for datatime search a in b where a= b

Community Support
1

Hi,

I want test kdb for 2GB database in csv but have problem with q
Can someone help me ?

Have
1table feed
feed:(“ZFFFFF”;enlist “,”) 0: :E:/feed.csv; dt,o,h,l,c,v`

2table strings
strings:(“ZSISFFFF”;enlist “;”) 0: :E:/strings.csv; dt,s1,i,s2,f1,f2,f3,f4`

In mysql - work ok:
query1)

SELECTdt,s1((h - l)
AS i2,s2,f1,f2,f3,f4
FROM strings a,feed b
WHERE a.feed = ‘my string’
&& a.dt=b.dt

In mysql - work to long hours..days : )
query2)

SELECTdt,s1((h - l)
AS i2,s2,f1,f2,f3,f4
FROM strings a,feed b
&& a.dt=b.dt

Want know what is best solution for this type.

2

 By s) I have error from kdb on. I say working ok but in mysql…

(Roundtrip: 000ms)
ERROR: 'join

Case from previous post is stil open…