| Index
» Projects
» phpMyEdit
» Forum
» slow work |
 |
svdesign
Joined: 21 Apr 2004
Posts: 2
Posted: 2004-04-21 15:28
Back to top
Reply with quote
|
Why phpMyEdit is very slow? Each page generate from 1 to 6 seconds even with very small mysql tables.
|
ajh
Joined: 17 Dec 2003
Posts: 236
Posted: 2004-04-22 08:25
Back to top
Reply with quote
|
Why is a piece of string long?
Maybe if you could describe your setup (machines, operating system etc), the config of your database etc then someone could help.
|
svdesign
Joined: 21 Apr 2004
Posts: 2
Posted: 2004-04-22 15:05
Back to top
Reply with quote
|
PHP 4.3.2, Mysql 4.0.13-nt
Very simple table, with 2-3 records:
| Code: |
CREATE TABLE 5k_lib_content (
content_id int(10) unsigned NOT NULL auto_increment,
lib_id int(10) NOT NULL default '0',
title varchar(255) NOT NULL default '',
contents text NOT NULL,
PRIMARY KEY (content_id),
KEY lib_id (lib_id)
) TYPE=MyISAM;
|
There is my options:
| Code: |
$opts['fdd']['content_id'] = array(
'name' => 'Content ID',
'select' => 'T',
'options' => 'AVCPDR', // auto increment
'maxlen' => 10,
'default' => '0',
'sort' => true
);
$opts['fdd']['lib_id'] = array(
'name' => 'Section',
'select' => 'T',
'maxlen' => 10,
'default' => '0',
'required' => true,
'sort' => false,
'values' => array('table' => '5k_lib', 'column' => 'lib_id', 'description' => 'title')
);
$opts['fdd']['title'] = array(
'name' => 'Title,
'select' => 'T',
'maxlen' => 255,
'required' => true,
'sort' => true
);
$opts['fdd']['contents'] = array(
'name' => 'Contents',
'select' => 'T',
'maxlen' => 65535,
'textarea' => array(
'rows' => 5,
'cols' => 50),
'required' => true,
'sort' => true
);
require_once 'phpMyEdit.class.php';
new phpMyEdit($opts);
|
|
|
Post new topic
Reply to topic
|
|
|
|
Login
Registration
Slovak
