RE: xPLMediaNet - Need some .net oledb help please

["Tony Tofts" <tony@xxxxxxxxxx>]

> Normally you don't need to specify autonums in insert
> statements - must be something else there.
> I think the easiest is to loop over the records and call the
> update yourself. It is what the DA would do for you anyway.

Hi Tom,

It's the inserting of new records that was the problem (rather than the
renaming in existing)

It complained I wasn't specifying a matching number of parameters (as I was
ignoring the autonumber)

> (but I tend to avoid autonums)

Yep, I think the hash is better in this instance?

The main worry about processing speed is that if there are a great number
of
changes the watcher buffers might overflow (and miss changes). This buffer
has to specified in 4kb chunks and doesn't page so the buffers eat up main
memory.

However, the files we're dealing with are large so there is time for
processing while copying is proceeding, and when you cut and paste a folder
structure (which could move a lot of files very fast) I've found that it
only raises events for the base folder, so this shouldn't overflow either.
So by default I'll set the buffers to a size of 8192 bytes with the option
to increase if needed.

Thanks
Tony



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx