Results 1 to 7 of 7

Thread: php

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128

    php

    web site 30 php. - hdd -.
    ?

  2. #2
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    30 , , ( ) , IIS. - -, 30- .
    , php ? .
    php , 80 KB . -. , - , . ?
    Last edited by Bombera; 16th December 2009 at 23:05.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  3. #3
    _
    Join Date: Apr:2006
    Location: _
    Posts: 1,128
    , mysql

    ?

  4. #4
    ! vbTheKing's Avatar
    Join Date: Sep:2003
    Location:
    Posts: 4,138
    Quote Originally Posted by Red_Leader View Post
    , . 10 000 - . - .

    Quote Originally Posted by Red_Leader View Post
    ?
    . - . - . xdebug
    ''? * *
    - !
    ...

  5. #5
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    . , , .
    :
    Code:
    SELECT u. * , COUNT( ccuptr.UNIT_ID ) AS USAGE_CNT, COUNT( guptr.MASTER_UNIT_ID ) AS USAGE_CNT_COMP
    FROM (
    
    SELECT z. * , uc.description AS CATEGORY_DESCRIPTION, SUM( guptr._COUNT ) AS UNITS_COUNT, COUNT( * ) AS UNIT_TYPES_COUNT
    FROM unitz z
    LEFT JOIN group_units_ptr guptr ON ( z.ID = guptr.UNIT_ID ) 
    LEFT JOIN unit_categories uc ON ( z.category_id = uc.id ) 
    GROUP BY z.ID
    )u
    LEFT JOIN group_units_ptr guptr ON ( guptr.MASTER_UNIT_ID = u.ID ) 
    LEFT JOIN conf_cat_units_ptr ccuptr ON ( u.ID = ccuptr.UNIT_ID ) 
    GROUP BY u.ID
    ..., , 6 -. - , , .

    - . t, .

    , mysqli , (prepared statements). InnoDB , , - . , . , - , -, .

    .. , , MySQL
    Last edited by Bombera; 16th December 2009 at 23:29.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

  6. #6
    Registered User
    Join Date: Jul:2005
    Location: Sofiq
    Posts: 2,798
    Quote Originally Posted by Bombera View Post
    :
    Code:
    SELECT u. * , COUNT( ccuptr.UNIT_ID ) AS USAGE_CNT, COUNT( guptr.MASTER_UNIT_ID ) AS USAGE_CNT_COMP
    FROM (
    
    SELECT z. * , uc.description AS CATEGORY_DESCRIPTION, SUM( guptr._COUNT ) AS UNITS_COUNT, COUNT( * ) AS UNIT_TYPES_COUNT
    FROM unitz z
    LEFT JOIN group_units_ptr guptr ON ( z.ID = guptr.UNIT_ID ) 
    LEFT JOIN unit_categories uc ON ( z.category_id = uc.id ) 
    GROUP BY z.ID
    )u
    LEFT JOIN group_units_ptr guptr ON ( guptr.MASTER_UNIT_ID = u.ID ) 
    LEFT JOIN conf_cat_units_ptr ccuptr ON ( u.ID = ccuptr.UNIT_ID ) 
    GROUP BY u.ID
    , . join "u" . , CREATE TEMPORARY, join- .

    . , .

    , DISTINCT .

    EXPLAIN . . , type != index . .

    , Bombera, .
    Last edited by _ShadoW_; 18th December 2009 at 13:56.

  7. #7
    Bombera's Avatar
    Join Date: Jul:2001
    Location: 4EVA
    Posts: 13,833
    , SELECT , , unitz 100- , . SELECT . -, . , , , , - , .
    " " , - , , . " !".
    , - . - " "

    , , , .
    Last edited by Bombera; 18th December 2009 at 14:49.
    EVGA X299 FTW K|i9-7960X@4.7|4x8 Patriot Viper Steel 4000|GTX 1660 Ti|970 EVO 1 TB|Seasonic Focus GX-1000|Xigmatek Elysium|
    Rampage IV Extreme BE|E5-1680v2@4.7|4x4 HyperX 1866|Cougar Aqua 240|GTX 1050 Ti|970 EVO 1/4 TB|CM 850 SilentPro|HAF-X|

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |