Professional Web Applications Themes

Performance issues - Coldfusion Server Administration

Hi all, just had a couple of performance questions for you to ponder... I am running a fairly large php/mysql app. In total it is only about 100 or so separate php files, but it is large because I have multiple clients and each currently gets their own directory with a copy of each of these files, which adds up quickly. My question is this... would it be better to give each client their own actual copy of each file, or would it be better to just have 1 copy of each file in a central location and serve the ...

  1. #1

    Default performance issues

    Hi all, just had a couple of performance questions for you to ponder...

    I am running a fairly large php/mysql app. In total it is only about
    100 or so separate php files, but it is large because I have multiple
    clients and each currently gets their own directory with a copy of each
    of these files, which adds up quickly.

    My question is this... would it be better to give each client their own
    actual copy of each file, or would it be better to just have 1 copy of
    each file in a central location and serve the right dynamic content
    depending on what certain session variables contain? (this is not a
    problem to do at all). My original thinking was that giving each client
    their own copy of all files would hopefully prevent problems with too
    many people trying to access a single file at the same time, but now I
    am wondering if in fact accessing multiple files at different places on
    the server would create problems itself. Also, the one copy method
    makes updates much easier as I only have to update one location. Does
    anyone know a rough estimate for a threshold of simultaneous or near
    simultaneous requests for a single file that Apache 1.3.x can handle
    without problems?

    My second and last question has to do with my database structure...
    currently, each client has their own tables in the database with a
    unique name they choose appended to all of their table names as a
    prefix. Would it instead be wiser to create an individual database for
    each client? My concern now is that when too many tables are created in
    my current database, there might be more overhead in performing
    queries... I am not sure which method would be more beneficial.

    Thanks so much in advance for any help you can provide.

    - Marcus

    Marcus Guest

  2. #2

    Default Re: performance issues

    On Mon, 13 Oct 2003 12:20:16 -0500, Marcus <JumpMan222aol.com> scrawled:
    >Hi all, just had a couple of performance questions for you to ponder...
    >
    >I am running a fairly large php/mysql app. In total it is only about
    >100 or so separate php files, but it is large because I have multiple
    >clients and each currently gets their own directory with a copy of each
    >of these files, which adds up quickly.
    >
    >My question is this... would it be better to give each client their own
    >actual copy of each file, or would it be better to just have 1 copy of
    >each file in a central location and serve the right dynamic content
    >depending on what certain session variables contain? (this is not a
    >problem to do at all). My original thinking was that giving each client
    >their own copy of all files would hopefully prevent problems with too
    >many people trying to access a single file at the same time, but now I
    >am wondering if in fact accessing multiple files at different places on
    >the server would create problems itself. Also, the one copy method
    >makes updates much easier as I only have to update one location. Does
    >anyone know a rough estimate for a threshold of simultaneous or near
    >simultaneous requests for a single file that Apache 1.3.x can handle
    >without problems?
    Don't use sessions - use a nice trick....

    Create a config directory which contains in it files of the form:

    [url]www.client1_site.com.inc[/url]
    [url]www.client2_site.com.inc[/url]
    [url]www.client3_site.com.inc[/url]

    and chose the appropriate config based on the server name, then
    you need just one copy of all the files. (this include file contains
    configurations for databases security etc)

    If there is different static content you may need separate directories
    for each of these subsections.
    >My second and last question has to do with my database structure...
    >currently, each client has their own tables in the database with a
    >unique name they choose appended to all of their table names as a
    >prefix. Would it instead be wiser to create an individual database for
    >each client? My concern now is that when too many tables are created in
    >my current database, there might be more overhead in performing
    >queries... I am not sure which method would be more beneficial.
    >
    I would chose different databases for each client - as it becomes much
    easier to back-up, and your code becomes simpler - no more

    "select * from $CLIENT"."_table1 where ID = 1"

    style queries

    just "select * from $CLIENT"."_table1 where ID = 1"

    Security of data is easier - you can have separate permissions for each
    one more easily;

    Maintenance is easier - I want a new databases..
    mysql -.. NEWCLIENT < schema.sql
    and away you go....
    >Thanks so much in advance for any help you can provide.
    >
    James Guest

  3. #3

    Default Performance issues

    We have just upgraded from ColdFusion 5.0 to ColdFusion MX(6.1) and the server
    performance has really degraded. Pulling up a page that queries a SQL database
    took 15 seconds in the past, now it's over 2 minutes. Looked through the
    doentation, altered settings with no improvement. Any suggestions would be
    greatly appreciated. Thanks

    Ruszaj Guest

  4. #4

    Default Re: Performance issues

    A well known issue caused mainly by the move from C++ to Java base code.

    Andrew.
    Andrew Dixon Guest

  5. #5

    Default Re: Performance issues

    How big are your servers (memory, cpu)?
    Do you have CF and SQL on the same server or are they seperate?
    Have you verified your queries to make sure they're using efficient SQL?
    Have you/do you use stored proecedures?
    Have you applied updater 1? How about other hotfixes?
    What config settings do you have for your datasource to the problem database?

    What kind of CPU load are you seeing on your machines?

    ke4pym Guest

Similar Threads

  1. Flash Performance issues
    By reach4thelasers in forum Macromedia Flash Player
    Replies: 17
    Last Post: February 19th, 02:30 PM
  2. Performance issues when tunneling???
    By Foppen in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: October 26th, 07:33 PM
  3. InDesign CS performance issues
    By Jon_Harm@adobeforums.com in forum Adobe Indesign Windows
    Replies: 3
    Last Post: June 8th, 06:15 PM
  4. Informix Performance Issues
    By Ajay Gopinath in forum Informix
    Replies: 1
    Last Post: August 4th, 03:13 AM
  5. Oracle 8.1.7.4 Performance Issues
    By Burkhard Kiesel in forum Oracle Server
    Replies: 4
    Last Post: December 16th, 10:55 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139