Re: free allocated memory: HOW ?
| From: | Stut | Date: | Thu, 12 Apr 2007 18:53:32 +0000 |
| Subject: | Re: free allocated memory: HOW ? | ||
| References: | 1 2 3 4 5 6 7 8 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-252777@lists.php.net to get a copy of this message | ||
Arthur Erdös wrote:
Ok, so when this database was "well designed" by the "mysql consultant" did you tell them about all the queries you would be running against it? If not, your statement oozes a lack of understanding concerning indexes and general database optimization. If that's the case, start Googling. Now. Before you write any more code. -StutArthur Erdös wrote:I suppose the database is not the problem, the indexes and foreign keys are all set correctly. we have the mysql enterprise version and had a mysql consultant here some time ago and our database is well designed.ok, its not really fast, but it runs on my development machine (AMD64, 4 GB of RAM, Ubuntu). mysql on the same machine, database with 175 tables and 2,3 GB data. that could probably slow down scripts, don't you agree?no. you have 4 F'ing gigs of ram on your desktop and it's a freakin' DB - they are supposed to handle *massive* ammounts of data ... you might consider analysing the queries you have and figuring out what an INDEX is for.