Re: Stop PHP execution on client connection closed
| From: | Marco Lanzotti | Date: | Thu, 15 Sep 2011 13:04:18 +0000 |
| Subject: | Re: Stop PHP execution on client connection closed | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-314870@lists.php.net to get a copy of this message | ||
Il 14/09/2011 19:34, Alex Nikitin ha scritto:
> Perhaps if I, or we can understand your application a little better,
> we could suggest better solutions, just remember that you are not the
> first person to have to solve these similar issues. I can help you if
> you want, glimpse over your database design and queries for a fresh
> look, i have fairly extensive php (and many other languages)
> programming experience, as well as database design and administration,
> system development and administration, optimization, security, caching
> (many other things, that don't directly pertain to this) though we
> should probably keep it off the list.
Table and queries are very simple.
Table is like this:
CREATE TABLE
TABLE1 (
ID int unsigned NOT NULL,
Service char(2) NOT NULL,
Lang char(2) NOT NULL,
Text1 varchar(100) DEFAULT NULL,
Char1 char(1) NOT NULL,
Date1 date NOT NULL,
Num1 int unsigned NOT NULL,
Num2 smallint unsigned NOT NULL,
Num3 smallint unsigned NOT NULL,
Num4 tinyint unsigned NOT NULL,
Num5 int unsigned NOT NULL,
Num6 tinyint NOT NULL,
Num7 int unsigned NOT NULL,
PRIMARY KEY (ID,Service,Lang),
KEY index_1 (Char1),
KEY index_2 (Date1),
KEY index_3 (Num1),
KEY index_4 (Num2),
KEY index_5 (Num3),
KEY index_6 (Num4),
KEY index_7 (Num5),
KEY index_8 (Num6),
KEY index_9 (Num7),
KEY index_10 (Text1)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
And this is an example query:
SELECT COUNT(*)
FROM TABLE1
WHERE Char1='A'
AND Num2=10
The WHERE clause can contain any indexed column.
Bye,
Marco