Perfrmance for datatime search a in b where a= b

[reptile]

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)

SELECT`dt`,`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)

SELECT`dt`,`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.

[reptile]

 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...