Dear RT types,
I am attempting to create a SearchBuilder driver for Sybase/Microsoft SQL
Server databases. I have some of the basics working but have hit some problems
I could use help with.
The first is that SearchBuilder does SELECTs always using the DISTINCT
keyword. This is a problem because SQL Server will not allow DISTINCT with
large object (type TEXT) fields. (They can be up to 2GB and I suppose the
comparisons could get expensive.)
My question is: Does anyone know, or, failing that, can anyone suggest a way
to find out where the DISTINCT clauses are really necessary?
I have not yet determined whether there is a means of telling SQL Server to
return rows distinct in every column not TEXT type.
Regards
Ian
Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420
Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420
Dear RT types,
I am attempting to create a SearchBuilder driver for Sybase/Microsoft SQL
Server databases. I have some of the basics working but have hit some problems
I could use help with.
I suspect that SearchBuilder’s query building probably needs to be
refactored to call out to methods in Handle, to allow easier
customization…It’s a fairly serious refactoring job, if you’re up for
it.
The first is that SearchBuilder does SELECTs always using the DISTINCT
keyword. This is a problem because SQL Server will not allow DISTINCT with
large object (type TEXT) fields. (They can be up to 2GB and I suppose the
comparisons could get expensive.)
My question is: Does anyone know, or, failing that, can anyone suggest a way
to find out where the DISTINCT clauses are really necessary?
Er. Just about everywhere. DBIx::SearchBuilder desperately needs the set
of rows returned to be unique.
I have not yet determined whether there is a means of telling SQL Server to
return rows distinct in every column not TEXT type.
Regards
Ian
Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420
–
Ian Grant, Computer Lab., William Gates Building, JJ Thomson Ave., Cambridge
Phone: +44 1223 334420
rt-devel mailing list
rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel
Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.