On Mon, 20 Jun 2005, Yuriy wrote:
>CS> When creating testtable, specify val as unique, and specify what to do
>CS> with conflicts:
>CS> CREATE TABLE testtable(val TEXT UNIQUE ON CONFLICT REPLACE);
>CS> The conflict clauses are documented here:
>CS> http://www.sqlite.org/lang_conflict.html
>Try it for ~1,000,000 UNIQUE records very slow :(
>and me need allso count this UNIQUE records. now i try keep count in
>the memory.
What are you actually trying to do? And can you quantify "very slow" and
tell us what you actually expect or what would be acceptable?
> [snip sample]
Is this representitive of what you are trying to do? Are you storing IP
addresses, and you want to discard duplicates? Using the "on conflict"
resolution is probably your fastest course of action.
>
>
>CS> If you want access to such functions, you must compile your own library
>CS> exporting the functions on Windows, and fix problems in the future if this
>CS> API changes at all.
>
>Can do this on Visual C++
>May be have examples? Or steps?
I don't work with VC, but I presume you can just create a new DLL project
(or workspace?) and add the SQLite source files, add your required build
flags, and create a DLL def file to export the various Btree functions you
require.
Christian
--
/"\
\ / ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
X - AGAINST MS ATTACHMENTS
/ \
