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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
