Slow Page Response With Database Driven Site
Jan 24, 2007
I have built a database driven site with PHP & MySQL. Pages download quicker on some connections than other (obviously), however this is not due to connection speed. The web host server seems to respond very slowly to my boss's network (which is on a proxy server). Could it be that this problem is related to the web host? i.e. could it be that the web host is unequipped to deal quickly with this type of network?
On my home connection (2Mbps), pages often download instantly, however occaisionally I have to wait 10-20 seconds to receive the page from the host.
Finally, could you recommend an excellent web host to use with our site? My boss wants to offer a professional service where server response is quick. We are based in the UK.
View 1 Replies
ADVERTISEMENT
Jan 23, 2009
I was curious to know a basic thing about hosting, i've always wondered is it possible to host a database driven website on one server and get the database picked form other server?
I mean place the database on different server, and connect to it on the other one, which is hosting the site, Are there any options available in the control panel?
View 10 Replies
View Related
Oct 29, 2008
I am trying to do something that I believe is fairly non-standard. What I am looking to do is create a system where I can rapidly deploy web sites without having to restart named and Apache. For example, if a customer completes a process, I want to be able to turn that site on immediately using a temporary domain (somecompany.example.com or othercompany.example.com).
With some programming language (hopefully PHP) I would like to get the customer up and running with their site immediately without having to restart the server. While doing some research I found I could use MyDNS which uses MySQL to manage DNS data instead of configuration files. MyDNS can be updated on the fly.
For Apache I have seen wildcard configurations, but everyone seems to be suggesting the use of mod rewrite. I would prefer that the domain maps directly to a specific folder:
somecompany.example.com -> /sites/somecompany/htdocs
(*.example.com -> /sites/*/htdocs)
Does anyone know how I might do this with Apache. It seems similar to user directories (example.com/~username -> /home/*/htdocs)
View 4 Replies
View Related
Mar 5, 2008
I am developer and I ahve done web-site development and database development but it was for other companies where everything was already available.
I was not sure if this was the right place for the post, but I thought I would atleast start here, if I should post this in some other category please let me know.
I am satrting work on a Database driven web-site. I say database driven, becuase the web-site copares prices for multiple products. By some worst case scenarios(explained later) I need a database to easily acoomadate more than 1000 GB of data. I can definitely try cutting this down, but my question is what type of hosting should I choose and how when the web-site is completely relying on data that is updated on a weekly basis.
The reason to keep old data is to use that to show a Price history and forecasting on future Prices. The thought of storing this data locally and just creating a summary has crossed my mind.
The Data Scenario:
Price of Products per store: 50,000
Approximate size for the table per store: 3 MB
Number of stores: 500
Avg Size: 1500 MB
This is the bare minimum 1500 MB + other tables + overhead
Other tables: Forum data, Reviewes, User Favorite Products, etc.
Number of weeks: 52
Avg Size: 78 GB
Howevere the table with the most data and the table that would be changing the most is the Price table. So I am approximating the minimum requirement for the Databse to be atleast 2GB.
My question now is:
To be cost effective I can store the history on my personal desktop. But I still need something that allows me to have 2 GB of Database space. What is my best solution?
I have no strict rules about platform or langauge, to get started I am just trying to be cheap but still find a decent web-hosting solution so that by getting started small I have hopes of going big.
View 12 Replies
View Related
Nov 6, 2008
I've been trying to get ahold of Awknet (www.awknet.com) Sales sector for about a week now and still no response :-( Does anyone have similar experience? Or maybe Awknet just didn't get my email? :<
View 6 Replies
View Related
May 9, 2007
I have Qmail installed on my Centos box. There seems to be some problem with connection because when I run DNSreport from dnsstuff.com on it it shows me that it cannot connect to mailserver.
I tried telnet from local and this is what happened...
telnet mail.mydomain.com 25
Trying XXX.XXX.XXX.XXX...
Connected to mail.mydomain.com (XXX.XXX.XXX.XXX).
Escape character is '^]'.
then nothing happens for a while (about 30s)
and then I receive this greetings message:
220 [mydomain.com] ESMTP NO UCE/SPAM on this server ESMTP
How can I speed up this process? Are there any lookups possible or what?
View 3 Replies
View Related
Jun 9, 2009
I have a dedicated server that I am renting that appears to randomly respond very slowly for some reason (pings are between 90-4000ms with about 75% packet loss).
This has been happening lately (about once a week for the past 4 weeks) and I thought I had originally found the cause of the problem but it appears I haven't.
Originally, when this problem was happening we were getting an abnormally high about of traffic but a reboot always fixed the issue. I've checked every where I can think of but I cannot find anything out of the ordinary.
ight now we're averaging less than 2Mbps in traffic, the CPU load is less than 0.75, the memory usage is at 55% with no swap being used, Apache connections are normal, no active SSH, FTP, or mail connections, I've restarted all services which had no impact, I've checked the access and error logs but can't see anything out of the ordinary.
I have a ticket open with the data center but I'm trying to figure this out on my own to fix whatever is causing this so I can move my data over to a new server we just got setup over the weekend in a local data center.
View 7 Replies
View Related
May 13, 2008
10 days ago, I require volumedrive.com assign another ip to my server.
Yestoday, I ask them again.
I hope donnot need another 10 days.
View 5 Replies
View Related
Dec 20, 2008
Limestone's support is extremely slow. I just got a server with them to host VPSes, so I was inquiring about additional IPs in case I needed them.
Their first two responses were within 4-5 hours, which is bearable. However, yesterday, I actually needed to order more IPs and posted a new reply. I have yet to receive a reply after over 12 hours and my client has been left waiting to receive the additional IPs he ordered.
I haven't been with Limestone long, and I haven't had much other experience with their support, but I was unsure what else to do other than post this here and hopefully get a resolution.
I know their servers are unmanaged and pretty cheap, but I think they should still take the time to answer tickets in a decent amount of time.
Has anyone had similar experiences with Limestone?
View 10 Replies
View Related
Oct 6, 2008
I recently made a shift to FDC for one of my servers that I use for downloadable content.
I went for a $199 server with a 100mbps shared bandwidth port. Now, the only problem I seem to be having with it is that downloads appear to be, I would say recognized, very slowly by the server before they start, however, once the download starts I get a full speed. This usually happens during peak times.
I'm using about 10/15mbps on the server according to my cPanel statistics. I just wanted to ask here prior to contacting FDC on this, whether this slow server response time has something to do with the bandwidth port, or perhaps the server's RAM, CPU, etc? Given I'm using quite minimal bandwidth on the port, should I consider having them fix this or upgrade the server instead?
And if I had to upgrade, would I need to upgrade the port or the RAM, or both for this?
View 3 Replies
View Related
Jul 11, 2008
Godaddy linux server respons very slow
View 6 Replies
View Related
Jun 18, 2008
This is in regard to ongoing stress I've had over this server from DN...
Keep in mind this is a NEW server order; my first with this company.
I was assigned IPs that appear to be on multiple spam block lists. The "biggest" problems are mail being dumped to bulk by yahoo and dumped to bulk or completely black holed by hotmail. It was also blocked by comcast, mail.ru, and anyone who uses SORBS (those are the only ones I KNOW about so far). This helps reinforce the suspicion that bulk mail was being delivered from the IPs at some point.
I Contacted support at 9PM on the 13th and was referred to abuse. Only after complaining again on the 17th, was I told they requested removal from ONE of the blacklists and they would "look into" the others. I replied saying I wanted new IPs or I would request a refund and that I did not feel the service I recently purchased was actually delivered.
Now here is the part that is giving me the feeling this will not end well for me; I no longer see the abuse department ticket when I log into their ticket system.
What If I ordered the server to use as a mail server? Am I out of line for finding a new server unable to deliver mail to the hotmail/yahoo inbox unacceptable?
Telling my customers to wait and maybe someday their mail will be delivered to the major free mail services is not the kind of reputation I want to have. Its feels like I was sold a problem someone else created and am expected to wait an unspecified amount of time to see if it can be resolved. I do not feel its fair to be left hanging while waiting for white listing attempts on IPs I did not soil in the first place.
I really hate bulk mailers and spammers. : /
View 10 Replies
View Related
Jun 16, 2015
We are seeing intermittent slow responses from SMTP on a RHEL6 server running Qmail on Plesk 11.5. The response is being measured from a remote Zabbix server.
The response time seems to be slow (>10s) for a period of 2-3 minutes and then returns to normal (<1s). All other services continue to be ok during the period of slowness.
The server_args line in /etc/xinetd.d/smtp_psa already contains "-Rt0" and all the DNS servers in /etc/resolv.conf are resolving properly.
From looking at the maillog file the server was receiving about 35 SMTP connections a minute at the time of the slowdown. We have the server configured to use 2 x RBL's.
I wonder if we are hitting a limit on the maximum amount of SMTP connections. The file /var/qmail/control/concurrencyincoming does not exist so, according to the Qmail manual, there shouldn't be a limit on the number of incoming SMTP connections.
View 9 Replies
View Related
Jan 22, 2014
I have Configured Apache2.4.4 for forward Proxy and tested from my browser the response is very slow and even not coming complete Response for some requests.
I also Tested the same for Apache2.2 Forward Proxy it is very fast and good.
May I know what is the Problem in Apache 2.4
Is there any Issues in proxy modules (mod_proxy,mod_proxy_connect.so,mod_proxy_http.so) in Apache2.4
This is the same configuration i used for Apache2.2 and Apache2.4
##########################################################################
## Apache Forward proxy
##########################################################################
<IfModule !proxy_module>
LoadModule proxy_module modules/mod_proxy.so
</IfModule>
<IfModule !proxy_connect_module>
LoadModule proxy_connect_module modules/mod_proxy_connect.so
[Code] ....
View 1 Replies
View Related
Aug 11, 2007
My server's experiencing very slow page loads.
I ran top and got this (screenshot attached)
Could we say that it is a bit high for one http process to use that much cpu/ram?
View 2 Replies
View Related
Dec 19, 2008
My site is very slow. But I can not find the reason.
Here is the top
Code:
top - 22:04:07 up 22:09, 1 user, load average: 0.44, 0.43, 0.34
Tasks: 402 total, 1 running, 401 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.3%us, 0.7%sy, 0.0%ni, 94.8%id, 0.1%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 2074804k total, 2007836k used, 66968k free, 72720k buffers
Swap: 4192956k total, 96k used, 4192860k free, 641728k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
17133 apache 20 0 27752 9.9m 3392 S 4 0.5 0:02.25 httpd
6306 apache 20 0 27772 9.9m 3452 S 4 0.5 0:08.04 httpd
2261 mysql 20 0 251m 88m 4752 S 3 4.3 48:25.58 mysqld
17081 apache 20 0 27700 9.9m 3496 S 2 0.5 0:02.81 httpd
17105 apache 20 0 27112 9504 3428 S 2 0.5 0:02.62 httpd
11844 apache 20 0 27756 9.9m 3444 S 0 0.5 0:06.21 httpd
13676 apache 20 0 27700 9.9m 3440 S 0 0.5 0:04.74 httpd
13718 apache 20 0 27424 9856 3448 S 0 0.5 0:04.83 httpd
16690 apache 20 0 26628 8980 3408 S 0 0.4 0:01.88 httpd
When run
[root@nd10749 ~]# netstat -an |grep 80 |wc -l
2788
It was able to handle over 5000 connection without problem.
When checked the log, can not find anything suspicous.
View 11 Replies
View Related
Apr 12, 2007
my site is terribly slow, especially if there are several users accessing it at once.
Is there a way to to find out what exactly is slow, so I know what to tackle?
Since there is no caching at the moment, I think that is a good point to start.
The reason that there is no caching, is because Internet Explorer kept showing stale content, whatever I tried. How do you make sure that IE doesn't cache the dynamic pages?
This also means that images are not cached and pages with several images, seem to load a lot slower, sometimes not even showing all images the first time the page is loaded.
Does anybody know what I can do to improve on this?
View 2 Replies
View Related
Oct 31, 2008
I had an VPS in SLHost and experiencing fall downs and slow server... now I moved and I check that the VPS is fast and great, but my sites are loading too slow...
I mean the connect time is too long; the time between connect and sending first byte goes from 5 to 12 seconds! My provider can't find what's wrong and I'm a little lost in this
View 6 Replies
View Related
Mar 22, 2007
I have a website www.officegofor.ca. The site takes a very long time to load. I don't think it's because of the server's connection speed. What would be the best way to diagnose the problem? What could the problem be? I noticed that it get's slower and slower with time and when I restart apache it's faster (but still not fast enough).
View 1 Replies
View Related
Dec 9, 2007
Usually I install every single PHP application on a new database. But I was thinking of installing a Joomla website and a SMF forum on one database with different table suffixes. Whether I install them in the same database or a different database, they will still be on the same host.
So does it make any difference to put them in different databases or should I just put them in one database?
The site/forum is for a little WoW guild website and it might get maybe 30ish visitors a day.
View 10 Replies
View Related
Mar 1, 2008
I rented a server from VD a month ago and hosted some of my websites. But I'm constantly noticing that my websites are loading very slow. How can I check if other users are experiencing the same problem, or if the problem lies with my Internet connection?
View 4 Replies
View Related
Nov 11, 2008
our VPS hosting company did an upgrade the other day and now something is wrong with our home page, it takes about 30sec to load. They keep saying its a php problem, but the scripting is fine, the engine is fine and the only thing that changed is that they did an upgrade.
They don't seem to be able to grasp the problem, and it is making my boss go nuts. A web guy a know said it definately had to be something at their end, and everyone else is at a loss.
View 14 Replies
View Related
Jul 1, 2007
My machine is pretty good. Here are the specs:
Intel Xeon-Woodcrest 5148-DualCore
3 gigs of ram
250GB Western Digital WD Cavia
I run a forum with a modest amount of traffic along with a content management system handling the other sections of the website. I'm pretty sure the forum isn't the problem though.
The server load for this machine is almost never above a 1. Right now as I type this the load is at 0.17, but it's unbearably slow! Taking up to 16 seconds to load a single page.
What could be causing this? I'm a server n00b. Is there a setting I should be doing to one of my servers configuration files to make it run faster?
My website gets 30-40,000 visitors a day and these problems always occur during peak hours. It would be easier to deal with this though if not for the fact that the server load is always so low. How is it possible for the site to get so slow while the server load is always so low?
View 14 Replies
View Related
Jun 29, 2009
I'm on a short assignment to inventory and manage the fixed assets of a small company, and we've just bought a web-based database for this purpose. While I'm pretty good at administering/running local databases, the web part has me stymied. Our company is between IT people, and there's no one on site with any more idea than I have about what's going on!!
Here's what I have so far:
--The company has a website which I'll call "ourwebsite.org" -- which I think, from searching the IP address the website points to, is hosted by HostMySite.com.
--There's also a record in DNS Management with the same name (ourwebsite.org), but pointing to our little server's local IP address.
--I need to find a way to get my database -- which I can access on the network at (server's IP address)/database (ie 0.0.00.0/database) -- online. I tried creating records in DNS Management (for ex., assets.ourwebsite.org) that point to our server's IP (the one that, if I type it in on the network, I can get to the site I'm looking for), but get generic "can't find the page" or "can't connect to the server" errors, even after 72 hours, when trying to access it from off the network.
--If I browse to assets.ourwebsite.org/database on the server itself, I get to the website! But if I go to that page from any other computer, on or off the network, it doesn't work.
--The Server is running Windows Server 2003
So, what are my options? Do I have to talk to the HostMySite.com people to add this page? Shouldn't I just be able to use my server's name (ourcompanyadc.ourcompany.org) and have that route to the server? What's going on here! Is there a simple way to get a tiny local-server-hosted website online outside of the network?
View 2 Replies
View Related
Jul 24, 2007
I am developing an application on a load balanced network.
It is configured as follows:
Webserver1, Webserver 2 (Fedora 5 - Linux, Apache, Zend Opt, PHP)
and a DataBase Server (MySQL)
When the webserver attempt to use the Database server the connections and page output are REALLY slow!
The database server is within the webservers local intranet - so I thought it would be a lot faster.
----------
Here is a quick test: : :
Testing Database Connection on localhost
Connecting to Database... 0.00054502487182617 seconds
SELECT * FROM users... 0.00076389312744141 seconds
Testing Database Connection on '192.168.1.200'
Connecting to Database... 19.998768091202 seconds
SELECT * FROM users... 0.0021719932556152 seconds
20 seconds to connect to the database server...
View 3 Replies
View Related
Oct 6, 2009
About the 28th September the host that I was with decided to move servers and did not inform me of this. They tried moving my site and after 18 hours of being offline decided not move my site. It came back offline, only the main page displayed but nothing else works, if you click on anything it goes to 404 page error. Only problem is, the page is displaying data up to 23rd September.
I have a blog and a forum connected and both seem to have lost all the data from the 23rd to 28th September. I have since moved host since the previous host not only did not inform me that they were moving, they didnt even bother taking a backup. I have been with my new host for over a week now so the propogation is definitely complete. Now the problem is whenever I open my blog, it keeps pointing to 23rd September (I have added a lot of posts since then). If I refresh the page, then it will show the latest posts. This is not a problem with the forum though, it works fine.
View 14 Replies
View Related
