- Original Message -
> From: "Jatin Davey"
> Subject: Re: SHOW FULL COLUMNS QUERIES hogging my CPU
>
> Certain part of our code uses DataNucleas while other parts of the code
A "data persistence product"... there's your problem.
Persisting objects into a relational database is like fitt
Hi Jatin,
On Jun 2, 2014, at 7:56 AM, Jatin Davey wrote:
> I found this blog while trying to find a fix for my problem. Thought it might
> be useful to share.
>
> Here it is:
>
> http://whirlpool.net.au/blog/5
To confirm - did you manage to fix your problem?
I was about to comment that it l
I found this blog while trying to find a fix for my problem. Thought it
might be useful to share.
Here it is:
http://whirlpool.net.au/blog/5
Thanks
Jatin
On 6/2/2014 8:22 PM, Jatin Davey wrote:
Certain part of our code uses DataNucleas while other parts of the
code use JDBC to access the DB.
All the "SHOW FULL COLUMN" queries that we do on the respective tables
are very small tables. They hardly cross 50 rows. Hence that is the
reason whenever these queries are made i can see high cpu usage in
%user_time. If it were very large tables then the cpu would be spending
lot of time in wa
Certain part of our code uses DataNucleas while other parts of the code
use JDBC to access the DB.
I would say that 70% of our code uses DataNucleas while the remaining
30% of our code uses JDBC for databases related operations.
Thanks
Jatin
On 6/2/2014 8:17 PM, Singer Wang wrote:
What's yo
What's your technology stack?
On Mon, Jun 2, 2014 at 10:21 AM, Jatin Davey wrote:
> On 6/2/2014 7:18 PM, Reindl Harald wrote:
>
>>
>> Am 02.06.2014 15:35, schrieb Jatin Davey:
>>
>>> I am no expert with mysql and databases. Hence seeking out some help on
>>> this forum.
>>>
>>> Basically i got
The advice to 'avoid LIKE in general' is a little strong. LIKE is
very useful and does not always cause inefficient queries, although
the possibility is there.
However, there is one form which must be avoided at all costs: the one
where the glob-text matcher is the first character in that string.
On 6/2/2014 7:18 PM, Reindl Harald wrote:
Am 02.06.2014 15:35, schrieb Jatin Davey:
I am no expert with mysql and databases. Hence seeking out some help on this
forum.
Basically i got a query dump of my application during its operation. I had
collected the queries for about 4 hours.
Ran some
Am 02.06.2014 15:35, schrieb Jatin Davey:
> I am no expert with mysql and databases. Hence seeking out some help on this
> forum.
>
> Basically i got a query dump of my application during its operation. I had
> collected the queries for about 4 hours.
> Ran some scripts on the number of querie
Hi All
I am no expert with mysql and databases. Hence seeking out some help on
this forum.
Basically i got a query dump of my application during its operation. I
had collected the queries for about 4 hours. Ran some scripts on the
number of queries being sent to the databases.
The query fi
10 matches
Mail list logo