6 messages in com.mysql.lists.win32Re: problems in mysql| From | Sent On | Attachments |
|---|---|---|
| SUDHA _RAMANATHAN | 31 Jul 2001 21:26 | |
| SUDHA _RAMANATHAN | 01 Aug 2001 00:52 | |
| Cynic | 01 Aug 2001 01:54 | |
| Michael Widenius | 03 Aug 2001 03:38 | |
| Chris | 07 Aug 2001 08:25 | |
| Michael Widenius | 08 Aug 2001 09:27 |
| Subject: | Re: problems in mysql |
|---|---|
| From: | Chris (chr...@netborders.com) |
| Date: | 08/07/2001 08:25:24 AM |
| List: | com.mysql.lists.win32 |
Quoting Michael Widenius <mon...@mysql.com>:
Hi!
"Chris" == Chris <chr...@netborders.com> writes:
<cut>
Chris> By the way the only thing I would like an improvement on Chris> is the speed on my win95 using MySql. Although my online Chris> Mysql server is brillantly fast having recently Chris> Php-Nuked one of my hosts with a long complicated Chris> database, my home Mysql one takes ages - Any sugestions Chris> or should I get a new machine! Chris> Would adding memory perhaps speed it up? Or are there Chris> any tweaks to the MySql files I could do to help Chris> performance?
Exactly what takes time;
- Connecting to a mysql server - Executing queries.
To be able to help you I would need to know a lot more about this.
Regards, Monty
PS: Send your problem report to mys...@lists.mysql.com with a CC to me, and I will see to it that you will get an answer.
------ Oops, apologies, Monty, original email was meant for the list too!
The main, or only problem I have with Mysql on home machine is the speed of executing queries via my own written php scripts and also others' software.
Clicking on a button on a webpage in my browser to call a script just hangs around for ages, machine whirring noises and eventaully the page appears then to get through a particular 'contact management' set of pages to see all updated info takes so long I give up and check the info on the Dos command line instead as its quicker. The reason for writing the scripts in the first place was to see a user friendly view of the info and easy click thru of each stage to add, delete or modify things as obviously the sql query is written into the script but then I have to write all the queries out by hand again on the Dos command which(if you just accidentally miss out and odd quote mark will not get you anywhere) is pain in the a...
Logging on at first and connecting seems fine. Simple scripts dont take too long, but the contact management set of scripts is cookie session controlled and takes ages. Also I have my own beta Php-Nuke version on home machine for testing new modules but ended up just adding another beta version online as its quicker to dialup, go to online server add, delete, modify etc. than it is do wait for a couple of pages to appear FROM the home version.
I hope this explains things. Can I adjust any MySql config files to make it run quicker on win95?
Regards, Chris