[EMAIL PROTECTED] wrote: > Hi group, > > when I run the slightly complicated command > > SELECT p.apr_id AS oo_id, p.apr_name AS oo_name, > p.apr_istStudent AS p_istStudent, > p.apr_fk_student_id AS p_fk_student_id, > sst_matrikelNr > FROM aa_personen p, as_studenten, as_studien, > as_studVerlaeufe vVerlaufEnde > WHERE p.apr_istGruppe = false > AND p.apr_istStudent = True > AND p.apr_fk_student_id = sst_id > AND sst_id = ssd_fk_student_id > AND vVerlaufEnde.ssv_id = ssd_fk_verlaufEnde_studVerl_id > AND ssd_ct_pruefung_status_id = 1 > AND vVerlaufEnde.ssv_ct_beendungGrund_id = 1 > AND ssd_fk_studiengang_id = 101 > > the error message 'Space for result tables exhausted' occurs. > If I just remove the last field from the command (i.e. without > ',sst_matrikelNr') 147 rows show without any problem. > I guess that 6 fields times 147 rows is not too many data but the > 'where' part of the command may be too complicated. Am I right? > > Is there anything I can do to overcome the limitations > without having to > reorganise the complete db structure? Would it help to take a newer > maxDB version? (Has the result table space increased?) > > Thanks in advance > Michael > > PS: I use MaxDB 7.5.26, database in ascii.
Hi, the statement doesn't looks very complicated to me. How large is your database and how much space is left on your data volumes? MaxDB writes result sets into the normal data area. So increasing your data volumes may help. Kind regards Holger -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
