ces ? Use top to find out.
What are the memory parameters used in my.cnf ?
The answers to these questions will provide some helpfull answers to
your
problem.
Simon
On Monday 30 Dec 2002 11:16 am, BPF Webmaster wrote:
> I migrated my site from a low end PC mutualized hosting to a brand new
>
I migrated my site from a low end PC mutualized hosting to a brand new
P3 1GHz 512M server I now manage myself. Unfortunately I found MySQL
slower now, the time for a PHP page is now about 6 seconds and was about
.6 before!!!
I haven't done any optimization and the DB is the same, so the size
(ab
Victoria,
So I looked deeper in my PHP code (I wrote it in February 2002) and saw
I use a REPLACE statement:
class persistent
{
// put method to save properties into the DB
function put($thePrefix)
{
// job no
',
`joined` bigint(20) default NULL,
`expired` bigint(20) default NULL,
`status` varchar(20) NOT NULL default '',
PRIMARY KEY (`account`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM
A+
JM
-Original Message-
From: Jocelyn Fournier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21,
Using PHP 4.2.3 with MySQL 3.23.52
Report:
---
- Table has 2 keys: 'account' as PRIMARY and 'id' as unique
- I make an SQL update on an existing a record with id="anid" setting
id="anotherid" but another record exists with id ="anotherid"
- The update is performed and the record already existi
Maybe try one line...
I got this tons of warnings this morning making an import from Excel.
But it was apparently successful...but all decimal value where store
truncated like 128.00 , the reason is I'm in France and Excel exports
decimal with coma 128,34 but MySQL expects 128.34 so I just replac
