Questions tagged [web-server]
The web-server tag has no summary.
30 questions
1 vote
0 answers
28 views
where is your vendor location from Composer?
My vendor directory from Composer is in the Home directory of my Linux user account. And I am very allergic to loading files into projects with something arbitrary as the user account name in the ...
- 43
0 votes
1 answer
875 views
IIS web application access SQL DB as service account
I've setup a new Python site on iis using FastCGI handler. The site has windows authentication enabled in iis and the app checks that the AD user belongs to an active directory group when they access ...
- 111
0 votes
1 answer
119 views
Different response time because it does not use the indexes created with the same query and same tables from the web server to the Oracle database
I have a database with Oracle 12c (12.1), where when making a query locally and even from TOAD or another remote tool, it returns the response in milliseconds, reviewing the execution plan I can see ...
- 169
-1 votes
2 answers
481 views
Creating Tables with the same table names from other databases doesn't have any bad effects?
I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
0 votes
1 answer
157 views
Web server accessing the database server in Always on availability group
We have a web server that is on the DMZ but that will need to query a database that resides inside the network. Now the network team wont allow port 1433 from the web server to the Database server. ...
- 1,117
0 votes
2 answers
72 views
Does my database need to connect to a server? [closed]
I'm very new to SQL and databases. I'm currently following this tutorial for creating a Magento website: https://www.tutorialspoint.com/magento/magento_installation.htm and I'm on Step 4. It says to ...
- 11
0 votes
2 answers
260 views
WARN max_connections from pt-variable-advisor - what to configure for DBaaS?
Our VM configuration (hosted on Vmware) # cat /proc/cpuinfo |grep "cpu cores" | awk -F: '{ num+=$2 } END{ print "cpu cores", num }' cpu cores 32 # free -h total used free ...
- 2,588
0 votes
1 answer
2k views
Two Oracle ORDS on one web server accessing one database
Oracle ORDS 3.0 Oracle 12c database Red Hat Linux 6.8 Tomcat 8.0.22 Can two ORDS be deployed to one web server (Tomcat) and access the same database? If so, how is this accomplished? That is, I would ...
- 237
1 vote
2 answers
5k views
What are possible ways of handling multiple users accessing the same database via custom web API? [closed]
I am very new to databases and Web design, but I understand enough to know that designing a good database is crucial, so I would like to prepare for that conceptually. However, I was unable to find ...
- 115
0 votes
1 answer
6k views
Where is the data stored in MySQL databases?
I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database. I have installed MySQL on macOS and I have ...
user120246
1 vote
1 answer
374 views
SQL Server Web Service in a web environment architecture
I am new at SQL Server web Service and not too knowledgeable in setting up a secure web environment... From what I've read until now regarding SQL Web Service, I would need to: 1. create a stored ...
- 1,093
1 vote
0 answers
2k views
SQL state S1000 in SQLConnect (but not all the time)
I have a CentOS6 webserver and a database server (MS SQL Server 2012). When I use the website everything is going fine except that once an hour or so I get a can't connect error in my php code. I ...
- 11
1 vote
1 answer
116 views
Sessionizing Web Log Data using MySQL (perhaps by simulating window functions)
I have a large MySQL Table containing about 15 Million rows of web log data. Depending on the IP, useragent and site_id (different sections on the website) I want to create user sessions. The session ...
- 55
6 votes
1 answer
2k views
Do multiple SQL Server instances increase security?
Context Let's assume you have a server which exposes a web server and one or more web services to store and manage sensible information about physical persons (assume, for this example, complete ...
- 163
0 votes
1 answer
66 views
Big Size Database and increasing number of users [closed]
Me and my colleagues are using quite big size normalized database. Basically it's used for warehouse management and daily minimum 100 of the user perform data manipulation operations. 80% of the ...
- 101