Apache OpenOffice (AOO) Bugzilla – Issue 20631
Large database ties up machine
Last modified: 2006-05-31 14:29:06 UTC
When opening up the 'view->data sources' or selecting 'mail merge' from a template, the data selection will jump the first table that has been defined as available. If this table has many rows, the machine will try to load them all with no limit. We have 1.2 million records in our contact database and will be adding 1 million per month. It would help if a default limit of 1000 records were placed on the data retrieval. An option to remove the limit would be needed but it would save users from having to kill the program and restarting. Or perhaps a contextual menu selection of 'execute' for each data source to retrieve the recordset would be better.
CLU: i cannot acknoledge that - in both cases only the first shown records are loaded and that usually is pretty fast - can you recheck that and have a closer look if maybe the network connection to the database server slow this prozess down?
.
correct the state
I still get the situation on more than one xp machine. I must define a small database or query or else the computer freezes as it loads up the first table it sees and runs out of virtual memory.
clu->jrf2112: sounds ugly - what database do you connect to, with which driver?
Using latest MySQL on Win2k and latest MyODBC on XP.
CLU->jrf2112: after rethinking this task, i came to 3 conclusions/questions 1. the idea with the limitation of readed in rows is an enhancement, so please write an enhancement (please take this task as reference for it) 2. i am not shure, if i understand you right: you only open the database beamer with F4? or you make something else in between f.e. you connect with any form or macro? 3. can you only open the big database with F4, and after the office is definetly gone, copy the ODBC log to this issue thx
CLU for protocol: tried it out with a big mysql database table (1 million records) over ODBC and it works fine under winxp and linux - must be a different problem
can anybody acknowledge this behavior and add a further description? i my case it still works well - has anybody additional info?
over a month no respond - not to repro, so i close this issue - do not hestitate to reopen this issue if you have further info
change subcomponent to 'none'