[prev in list] [next in list] [prev in thread] [next in thread]
List: openjms-user
Subject: RE: AW: [openjms-user] Performance Issues
From: Dan Gavenda <djgavenda2 () yahoo ! com>
Date: 2004-06-01 19:59:19
Message-ID: 20040601195919.90554.qmail () web41406 ! mail ! yahoo ! com
[Download RAW message or body]
I am now encountering a very odd problem. I am not
sure it's if my configuration, software or possibly
hardware.
With all the performance enhancements, I do see a
difference but I have noticed that when I do not press
a key or move the mouse (i think any h/w interrupt
would work) it will take >2.5 mins. With a h/w
interrupt, it's instanteous. I have noticed some
NIC's are better or worse than others.
The problem happens when trying to set up the topic or
queue.
Has anyone seen anything like this??
--- Preston <mcfarlandp@posim.net> wrote:
> Every table has a single unique index on it. It's my
> assumption that
> these are the columns that compose the primary key.
>
> With Sybase the primary key also contains a unique
> index by default. In
> our scripts we don't create the indexes just the
> primary keys. You'll
> have to do whatever is appropriate for your db.
>
> Preston
>
> -----Original Message-----
> From: openjms-user-admin@lists.sourceforge.net
> [mailto:openjms-user-admin@lists.sourceforge.net] On
> Behalf Of Dan
> Gavenda
> Sent: Thursday, May 27, 2004 3:33 PM
> To: openjms-user@lists.sourceforge.net
> Subject: Re: AW: [openjms-user] Performance Issues
>
> Michael and Preston,
>
> Much thanks....have one more question.
>
> How do I know what the use for primary keys for the
> db? I would prefer not to 'guesstimate'. Do one
> of you know this?
>
> --- Michael Jaszczyk <mjaszczyk@pironet-ndh.com>
> wrote:
> > Hi,
> >
> > I just noticed, that I send the Code Patches for
> > issue 3 to the dev mailing
> > list instead of opening up a bug and attaching
> them
> > to it.
> > I will do this, hopefully before the weekend.
> >
> > Michael
> >
> >
> > > -----Ursprungliche Nachricht-----
> > > Von: Preston [mailto:mcfarlandp@posim.net]
> > > Gesendet: Mittwoch, 26. Mai 2004 21:21
> > > An: openjms-user@lists.sourceforge.net
> > > Betreff: RE: [openjms-user] Performance Issues
> > >
> > >
> > > Hi Dan,
> > >
> > > The improvements that need to be made fall into
> > three categories:
> > >
> > > 1. Some indexes are needed. For the moment we've
> > only added 1
> > > additional
> > > index, but I'm sure a more thorough examination
> > would show more are
> > > needed.
> > > create index message_handles_expiryTime on
> > PosimJMS.message_handles (
> > > expiryTime ASC
> > > )
> > >
> > >
> > > 2. There are no primary keys defined within the
> > tables. There
> > > are unique
> > > indexes, but the primary key itself is not
> defined
> > (I'm
> > > speaking for ASA
> > > but assume the other DB scripts behave the
> same).
> > You'll have
> > > to add the
> > > primary key. "If no primary key is assigned, all
> > the columns together
> > > become the primary key."
> > >
> > > 3. Most (it may be all) of the calls to the
> > database do something like
> > > "select * from whatever" when only 1 or 2
> columns
> > are required. This
> > > results in slower execution times. To fix this
> you
> > will have to modify
> > > your source code accordingly.
> > >
> > > I double checked and Michael's patch was
> > submitted. You can find it at
> > >
> >
>
http://sourceforge.net/tracker/index.php?func=detail&aid=87294
> > 7&group_id
> > =54559&atid=474136
> >
> > It states "Attached patch for create_oracle.sql
> adds
> > index on expirytime
> > and destinatioinid to avoid full tables scans.
> Might
> > be a good idea for
> > other rdbms, too."
> >
> > If all it addresses are the creation scripts
> you'll
> > have to fix issue 3
> > yourself.
> >
> >
> > HTH,
> > Preston
> >
> >
> >
> >
> >
> >
>
-------------------------------------------------------
> > This SF.Net email is sponsored by: Oracle 10g
> > Get certified on the hottest thing ever to hit the
> > market... Oracle 10g.
> > Take an Oracle 10g class now, and we'll give you
> the
> > exam FREE.
> >
>
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > _______________________________________________
> > openjms-user mailing list
> > openjms-user@lists.sourceforge.net
> >
>
https://lists.sourceforge.net/lists/listinfo/openjms-user
> >
> >
> >
>
-------------------------------------------------------
> > This SF.Net email is sponsored by: Oracle 10g
> > Get certified on the hottest thing ever to hit the
> > market... Oracle 10g.
> > Take an Oracle 10g class now, and we'll give you
> the
> > exam FREE.
> >
>
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > _______________________________________________
> > openjms-user mailing list
> > openjms-user@lists.sourceforge.net
> >
>
https://lists.sourceforge.net/lists/listinfo/openjms-user
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/
>
>
>
-------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the
> market... Oracle 10g.
>
> Take an Oracle 10g class now, and we'll give you the
> exam FREE.
>
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> openjms-user mailing list
> openjms-user@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/openjms-user
>
>
>
>
>
>
-------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the
> market... Oracle 10g.
> Take an Oracle 10g class now, and we'll give you the
> exam FREE.
>
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> openjms-user mailing list
> openjms-user@lists.sourceforge.net
>
https://lists.sourceforge.net/lists/listinfo/openjms-user
__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/
-------------------------------------------------------
This SF.Net email is sponsored by the new InstallShield X.
From Windows to Linux, servers to mobile, InstallShield X is the one
installation-authoring solution that does it all. Learn more and
evaluate today! http://www.installshield.com/Dev2Dev/0504
_______________________________________________
openjms-user mailing list
openjms-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openjms-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic