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.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
