|
|
Posted by Gary L. Burnore on 11/13/65 11:30
On 26 Oct 2005 11:40:09 -0700, smorrey@gmail.com top posted like a
newbie and wrote:
>Ok, I don't know how but this got places in the wrong order in the News
>Group.
>Anyways problem is solved.
You might also try the new comp.databases.mysql newsgroup for further
mysql questions.
>
>smorrey@gmail.com wrote:
>> Ok, thanks that helps quite a bit, the single user page load was cut by
>> 25% by using phpmyadmin to create indexes on from_user and to_user,
>> which I assume is what you meant, since I have no clue how to create an
>> index any other way.
>>
>> But the page load times are still spectacularly high.
>> It seems to me, that this should still be something handled via a
>> simple DB query.
>> I mean really it SHOULD be as simple as SELECT SUM(to_amount) WHERE
>> to_user = 1 - SUM(from_amount) WHERE from_user = 1
>>
>> However that doesn't appear to work either :(
>>
>> Steve wrote:
>> > > This works great, so I populated the DB with over 100,000 records and
>> > > now page loads take 75-80 seconds for the total balance sheet page (I
>> > > just loop through each user, and there are 100 users), and upwards of
>> > > 10 seconds on a single user query.
>> >
>> > Forget the SQL, the syntax is all over the place. Go back to the
>> > original queries, but create indexes on columns `from_user` and
>> > `to_user`.
>> >
>> > ---
>> > Steve
--
gburnore at DataBasix dot Com
---------------------------------------------------------------------------
How you look depends on where you go.
---------------------------------------------------------------------------
Gary L. Burnore | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
Official .sig, Accept no substitutes. | ÝÛ³ºÝ³Þ³ºÝ³³Ýۺݳ޳ºÝ³Ý³Þ³ºÝ³ÝÝÛ³
| ÝÛ 0 1 7 2 3 / Ý³Þ 3 7 4 9 3 0 Û³
Black Helicopter Repair Services, Ltd.| Official Proof of Purchase
===========================================================================
Navigation:
[Reply to this message]
|