1) How many joins per stmt allowed ? 2) outer join support ?
3) re: performance: have you considered collecting COUNT(*) from each datasource (where available), and then shipping the data from the smaller resultset directly to the datasource with the larger resultset ? (not certain how feasible this is for all platforms, esp. wrt filtering out dup rows, but I think its - in part - how Mariposa supposedly works) 4) I concur that SQL extensions are better than DBI; have you considered a DBIx subclass implementation, ala DBIx::Chart ? 5) Distributed INSERT ... SELECT, UPDATE..FROM, or DELETE ... WHERE x IN (SELECT...) supported ? (possible transactional issues, I suppose...) 6) Any minimum i/f requirements from the underlying DBD's ? 7) Eagerly awaiting its arrival! Dean Arnold Presicient Corp.
