Hallo Holger,
thanks for your answer. It solved the problem.
The data volume had the size of 50MB and 50% of it were filled.
I increased it to 150MB and it worked fine.
However, in another case, the number of resulting rows was 250 and
not only 147 (as in the mentioned case). I had to increase the volume
again to avoid the error 'Space for result tables exhausted'. This time I
chose 350MB and again it worked.
Though increasing the volumes seem to be a solution the needed space
scales "badly" with the number of resulting rows. Thus, I guess I still
have to restructure the db to get a solution with better scaling.
If you have an idea why it scales "badly" your suggestions will be
very appreciated.
- -
Becker, Holger schrieb:
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
[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.
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
