Dear all,
MySQL 4.0 becomes slowing down on 20 of records on patient visit.
Especially when browsing, data of wards and its waiting list patients. I am
trying to tune the mysql Server increasing file size and also buffer.
Is there any one who solved the problem to make it faster Mysql server
On 17/07/2007, at 8:33 PM, K2O2 wrote:
> Dear all,
>
> MySQL 4.0 becomes slowing down on 20 of records on patient
> visit. Especially when browsing, data of wards and its waiting list
> patients. I am trying to tune the mysql Server increasing file size
> and also buffer.
>
> Is there a
Hello all,
> > MySQL 4.0 becomes slowing down on 20 of records on patient
> > visit. Especially when browsing, data of wards and its waiting list
> > patients. I am trying to tune the mysql Server increasing file size
> > and also buffer.
> >
> > Is there any one who solved the problem to make
On 17/07/2007, at 9:19 PM, K2O2 wrote:
> Well,
>
> Here is my server spec. HP proliant dl 380 G5 Intel Xeon 3.0GHz.
> 2GB RAM. Running CentOS 4. Hoping that server is quite ok. Please
> check that variables.
> mysql> SHOW VARIABLES;
Hi K2O2,
You could increase your key_buffer and join_buffe
On 17/07/2007, at 9:44 PM, K2O2 wrote:
> Here again,
OK. There is no table locks showing up here, so that should be okay,
so I am suggesting it is coming back to the indexing or the query
structure.
Is the query being logged at all?
Regards
Jonathon
>
> mysql> SHOW STATUS;
> +-
Make sure the query has an "order by". I swear I found not having an "order by" changed a query of 400,000 customers in a mysql system from 2 minutes to 10 seconds once. Never looked into it thoroughly as I very seldom have that concern. For certain, there are always more and less efficient ways t
Ok. I will try and I will let you know. Yeh, I better try right now. !
regards,
kko!@
==
On 7/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Make sure the query has an "order by". I swear I found not having an
"order by" changed a query of 400,000
Hi Carers
Due to the inutilizzation of the db_abstraction/ and php5_compatibility/ rep
SVN (over 5 mounth) they will be deleted.
New branches added: 3th_generation/ with seagull framework, for test
purpose.
All developer are invited to test the tool.
Regards
Claudio
--
Hi All,
I am developing insurance system for care2x, please give me a simple page
which has some template file, using template variables, some language file,
and a php file to execute.
This will help every one who wants to understand the structure of the
care2x, although there is very good do
9 matches
Mail list logo
