[sqlite] cross join very slow, which is better select virtually using cross join, or create physically data output from cross join?

are 256 row. I know that the value of max will be 8*4, I just want to know the speed to get maximum number from column calculation using cartesian list. Is there a better/fast way to get data combination of column text8, or I have to store it physically into table? Thanks in advance, -iip

Re: [sqlite] cross join very slow, which is better select virtually using cross join, or create physically data output from cross join?

On Sun, Jun 12, 2011 at 8:58 PM, Igor Tandetnik itandet...@mvps.org wrote: iip iip.umar.ri...@gmail.com wrote: I tried to create Cartesian list from 8 digit text that has 256 row. when I try below statement, the time to fetch the result was very long, I'm always press ctrl+c because its

[sqlite] How to search column ascii containing chr(0)

Hi All, As subject, I want to know how search column that contain ascii chr(0), I already use google to search but no luck, I'm using python language. Thanks in advance, -iip- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org

Re: [sqlite] How to search column ascii containing chr(0)

On Sun, Jun 5, 2011 at 8:47 PM, Igor Tandetnik itandet...@mvps.org wrote: iip iip.umar.ri...@gmail.com wrote: As subject, I want to know how search column that contain ascii chr(0) select * from MyTable where hex(MyField) like '%00%'; -- Igor Tandetnik yes, I already did that, so