Sent: Wednesday, March 26, 2003 3:13
PM
Subject: [jdjlist] Re: String List
Compare
Dear DR, sorry but I can't give you any details, and here is
why:
1) The one reason for the predicament is that legacy DB
structure is horrible, and this query will be 2 pages long, and not likely
to EVER come up again (I sincerely hope others do not have the same to deal
with!!)
2) Explanation will take 2-3 pages, time I do not
have.
3) I'm still coding the solution!!!
4) I can't reveal the particulars of the IMX
internal DB structure... do you want the Lawyers after both of us??!!
:-)
But seriously, the point was that using the SQL LIKE *is*
the solution here. As long as you can bypass any String operations in
Java and twist and turn your (even VERY, VERY, VERY badly designed) legacy
table structure around so you can somehow (self-join, union, group by N
different columns together, etc.) do it in the SQL in the DB, you're way way
ahead of any Java solution. That is the take-home lesson
here.
But if you have some kind of tricky problem YOU are working
on, post away, I'd love to have a crack at it!
Cheers!
Greg
-----Original Message-----
From:
David Rosenstrauch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 26, 2003 2:49 PM
To: jdjlist
Subject: [jdjlist] Re: String
List Compare
On Wednesday 26 March 2003 04:05 pm, you wrote:
> Fortunately, not all of the 45000 are used every time,
and then not all
> of them are the list...
Anyway, no more worries!! I just had a very
>
intense brainstorming session with our group and we came up with an
> awsome way to use the SQL LIKE '%CA%' -- this is going
to be SUPERFAST.
> No Java String operation will
be able to touch this new SQL, ever.
>
> Thanks to all who pitched in.
>
> :->
>
> Greg
What? Rope us all in, throw out the teaser of a
super-fast solution, and then
leave us
hanging?!?!?!? :-)
Please do share your solution with the list!
Curiously yours,
DR
---
You are currently subscribed to
jdjlist as: [EMAIL PROTECTED]
To unsubscribe
send a blank email to [EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
---
You are currently subscribed to jdjlist as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
http://www.sys-con.com/fusetalk
---