Professional Web Applications Themes

How to High speed data fetch from DB ? - MySQL

I am not at all a DB expert but my question is that given that, queries to a DB are properly optimized, DB schema is proper & sufficient hardware resources are in place, how can I make my queries run faster ?? I have queries which count and evaluate statistics from 6 month old customer data (like going through millions of records), sometimes for a 100's of customers and sometimes even fetching all records a month old. The system is MySQL 4.0 based with InnoDB tables. There is no parallelization or clustering concepts used. I know it's a very open-ended ...

  1. #1

    Default How to High speed data fetch from DB ?

    I am not at all a DB expert but my question is that given that, queries
    to a DB are properly optimized, DB schema is proper & sufficient
    hardware resources are in place, how can I make my queries run faster
    ??

    I have queries which count and evaluate statistics from 6 month old
    customer data (like going through millions of records), sometimes for a
    100's of customers and sometimes even fetching all records a month old.

    The system is MySQL 4.0 based with InnoDB tables. There is no
    parallelization or clustering concepts used.

    I know it's a very open-ended question, but in essence how should one
    speed up the queries.

    Should I study query optimization algorithms & figure out which
    commercial/open source DB has the best performing algos & buy that OR
    study how to write a query to make it illicit a certain algoritm
    behavior/query plan OR play with DB caching techniques ... What are the
    steps to be taken ?

    rchadda@gmail.com Guest

  2. #2

    Default Re: How to High speed data fetch from DB ?


    [email]rchadda[/email] 寫道:
    > I am not at all a DB expert but my question is that given that, queries
    > to a DB are properly optimized, DB schema is proper & sufficient
    > hardware resources are in place, how can I make my queries run faster
    > ??
    >
    > I have queries which count and evaluate statistics from 6 month old
    > customer data (like going through millions of records), sometimes for a
    > 100's of customers and sometimes even fetching all records a month old.
    >
    > The system is MySQL 4.0 based with InnoDB tables. There is no
    > parallelization or clustering concepts used.
    >
    > I know it's a very open-ended question, but in essence how should one
    > speed up the queries.
    >
    > Should I study query optimization algorithms & figure out which
    > commercial/open source DB has the best performing algos & buy that OR
    > study how to write a query to make it illicit a certain algoritm
    > behavior/query plan OR play with DB caching techniques ... What are the
    > steps to be taken ?
    the best solution is to cache the queries' results in the memory, e.g.
    memcached

    howachen@gmail.com Guest

Similar Threads

  1. Fetch large data
    By rajsinha in forum Coldfusion Database Access
    Replies: 3
    Last Post: October 13th, 08:57 PM
  2. future of high-speed cable modems?
    By Midnight Java Junkie in forum ASP.NET Building Controls
    Replies: 0
    Last Post: June 20th, 06:59 AM
  3. Fetch Data From DB Into Array
    By Andy Hassall in forum PHP Development
    Replies: 0
    Last Post: August 31st, 09:56 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