In my query table1 and table2 have about ~70
records, table3 ~50 records. The result set is
~1 records. It sems to me that the bigger the
tables the bigger performance difference.
--- [EMAIL PROTECTED] wrote:
> I am curious how many rows are in each of your test
> tables. Have you trie
I am curious how many rows are in each of your test tables. Have you tried
this with a few million rows in each table?
Alexei Novakov <[EMAIL PROTECTED]>
03/10/2004 01:22 PM
To: [EMAIL PROTECTED]
cc: (bcc: Josh Ralph/IS/Expeditors)
Subject:Out
Hi All,
I don't really know DB which is doing fine with
optimization of outer joins. MaxDB is not an
exception. I think there is room for optimization
though. Let's look at the following example:
1)
select t1.col1, t2.col1, t3.val
from table1 t1, table2.t2
left outer join table3 t3
on t3.col1 = t
Hello all,
I've been playing around with param_checkall, and I've found something I
don't quite understand.
According to the docs:
param_checkall with no arguments does this:
"The system default values are used for all parameters (necessary
for background processing)."
param_checkall GENE
Hi:
Why in the Database Manager appear that the DataBase has 102 used
sessions, and in the Information - Sessions only has 93 sessions?
Thanks
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I finally managed to get 7.4.03-B31 "ported" so Solaris/x86,
Great.
> executed all
> the regression tests successfully. The process has been mainly
[...]
> The same has been done for 7.5.01-BETA.
>
>
> My questions are:
>
> - How to submit the patches (and to whom)?
> - is there hope that t
what if you put "" around it?
"Robert Meier" <[EMAIL PROTECTED]>
03/10/2004 04:19 AM
To: <[EMAIL PROTECTED]>
cc: (bcc: Josh Ralph/IS/Expeditors)
Subject:Password Spec's
Hi,
Just a quick question, which characters are allowed in passwords fo
Both our Problem Tracking System (http://www.sapdb.org/webpts) and the CVS server are
now available again and should get daily updates.
Due to changes inside the SAP network, configurations and permissions had to be
reapplied. This process took longer than expected.
We're sorry that we couldn
I finally managed to get 7.4.03-B31 "ported" so Solaris/x86, executed all
the regression tests successfully. The process has been mainly
- adding conditions in the source files
(predominantly adding "|| defined(SVR4)" )
- adding conditions for SVR4 to the desc files
|| defined (SVR4)
-ldl
-
Oh, well, that's embarassingly obvious! Thanks. Then there must be an
error in my program, because it should have removed the referencing
foreign keys first. Easy to verify that and I probably should have
checked that. Your explanation makes absolute sense.
Best regards,
Robert
Anhaus, Thomas
[EMAIL PROTECTED] wrote:
> >after some discussion the only reason we could found for
> this exclusive
> >locks was that they should guarantee that the result of a
> long running
> >update statistic command could be inserted into the system
> table without
> >a collison with another transactio
On Wed, 10 Mar 2004 11:17:11 +0100, Zabach, Elke <[EMAIL PROTECTED]>
wrote:
Dusan Kolesar wrote:
Hello,
I have one problematic trigger.
When I insert into LEVEL table, all database instance crash down.
When there is the same trigger but without 2 lines:
line 16 and 31 is EXECUTE insertstmt;
e
Hi,
Just a quick question, which characters are allowed in passwords for
users such as DOMAIN, SUPERDBA and CONTROL? When I try to use characters
such as ?,*,$ etc I seem to pickup endless problems with dbmcli esp.
loading the systabs and other areas!
If these characters are not allowed then su
Dusan Kolesar wrote:
>
>
> Hello,
>
> I have one problematic trigger.
> When I insert into LEVEL table, all database instance crash down.
> When there is the same trigger but without 2 lines:
> line 16 and 31 is EXECUTE insertstmt;
> everything is running and in the debug table TEST I can see
Dusan Kolesar wrote :
>Hello,
>I have one problematic trigger.
>When I insert into LEVEL table, all database instance crash down.
>When there is the same trigger but without 2 lines:
>line 16 and 31 is EXECUTE insertstmt;
>everything is running and in the debug table TEST I can see all correct
>
If you want to rollback committed actions like a delete or drop by mistake you have to
use point-in-time-recovery (until option) otherwise every action committed is always
recovered. This is a basic feature of a database.
Please have a look into the papers which describe the recovery abilities.
K
Hello Uwe!
Well, I see, but the problem is the following:
Before I do the Backup of the DATA and the LOG, I insert some stuff into
some tables.
So far so good.
Right after the backup, I delete this data from the database.
Then I do a recover..and ups.the data which are supposed to be in
Hello,
I have one problematic trigger.
When I insert into LEVEL table, all database instance crash down.
When there is the same trigger but without 2 lines:
line 16 and 31 is EXECUTE insertstmt;
everything is running and in the debug table TEST I can see all correct
insert statemants.
Trigger is
Hi Christoph,
when log is backuped it is not deleted - it may be overwritten.
In your test the recovered data backup finds its corresponding log in the log volume.
You do not need to recover log from a log backup.
The call of "db_restartinfo" shows you if you need a log backup to recover or not
Hello All!
I'll do a backup of my database using following comamnds:
autolog_off
medium_put test_backup c:\test FILE DATA 0 8 YES
medium_put test_backup_log c:\test_log FILE LOG 0 8 YES
backup_start test_backup
backup_start test_backup_log
autolog_on
Now I got the Complete Backup in a File calle
Georg Thome wrote:
> Moin Holger,
>
> thank you very much for your attention.
> That seem to be good news.
> Anyway the change of the "update statistik" to the "estimate sample"
> version saves already a lot of hours so that we are hopefully not
> running into production time.
> Is it possible
21 matches
Mail list logo
