[prev in list] [next in list] [prev in thread] [next in thread] 

List:       solid
Subject:    Two big problems with solid 2.3
From:       Yann Doussot <doussot () gifrance ! com>
Date:       1998-08-23 16:42:30
[Download RAW message or body]


	Hello,

	I have two serious problems with Solid 2.3 (Linux MT version):

	- First, when Solid make a check point, the server is absolutely
unusable : load goes up to 10 during 1 minute ! Nothing can be done on the
computer until it finishes the check point. (server is a PII 266 with scsi
raid disks). Database file is around 200Mo, but only a small part is used
I think ( I did a lot of inserts but deleted everything later). I read the
manual several times, but it's not clear for me what Solid is doing during
a check point, and how I can tune my solid.ini to avoid this load.

	- Second I'm trying to create a script that dump/reload the whole
database (tables, datas, procedures, sequences). Everything work fine (I
followed what's explained in Solid Admin guide) except procedures. The
soldd.sql calls 'SET SCHEMA' before creating procedures but the procedures
are created with the dba as owner. This is a serious problem when two
users have created procedures with the same name.

	Any suggestion welcome. Thanks.

---
Yann Doussot <doussot@gifrance.com>
Grey Interactive - France - http://www.gifrance.com/
Cell: +33 6 12 71 70 03   Work: + 33 1 46 84 85 00

[prev in list] [next in list] [prev in thread] [next in thread]