Re: 7.x -> 5.x joins

At 09:09 PM 8/4/98 -0700, Jair wrote: >Ron: > The 7.x INFORMIX ver makes the transformation of differents types of data, >well the thing is if you join of a char type with an integer the engine makes >the conversion of data types before retriving the data so you better check the >types between de new instance and the old one. > Nope, the data types were identical. I have now discovered that this condition is regularly occuring on many different 7x/5x joins, so it's not just that query. I'm leaning more towards the theory of "don't use the release ending in 00" (i.e., my 5.00 release). But I'm sure that there are a number of shops that do 7x/5x joins, so there must be some way to do this! Any other thoughts? Thanks, Ron >Ron M. Flannery wrote: > >> I'm currently migrating a bunch of 5x databases to 7x. We're migrating >> one database at a time. The old databases are running on a >> Compaq Sypro running SCO and Online version 5.00.UD6. The new databases >> are on an HP running IDS 7.24.UC3. When I run a particular query on the >> 7x instance and join to the other instance, it takes an incredible >> amount of time (query supplied below). If I eliminate the 7x table from >> the query and just access the 5x tables, it works great. So it seems >> like the problems only occur when doing this particular join. The table >> sizes are fairly small, about 50-60K rows. >> >> Has anyone else run into such a problem and how might I go about fixing it? >> >> Thanks, >> Ron >> >> QUERY (7x local table is uxct; the others are on 5x): >> select >> uxct.sno,uxct.uocc_no,uxct.cov_type,uxct.xact_date,uxct.amount, >> uxct.pay_fyear >> ,uocc.fyear ,occ.occ_auth_code,occ.occ_fyear,occ.occ_mbr_no, >> occ.occ_seq_no >> ,occ.occ_close_date,occ.occ_rptd_date,occ.occ_date,mbr.mbr_name >> >> from uxct, uocc, occ, mbr >> where uxct.rins_code = '10' and uxct.xact_type = 'P' and >> uxct.pay_fyear >= 1998 and uxct.pay_fyear <= 1998 and uxct.uocc_no = >> uocc.uocc_no and uocc.uocc_no = occ.uocc_no and occ.occ_mbr_no = >> mbr.mbr_no and occ.occ_auth_code= mbr.mbr_auth_code ; > > > > Ron Flannery | President, rflanner@one-point.com | Michigan Informix User Group President, One Point Solutions| http://www.miug.com http://www.one-point.com voice=248.887.8470