Questions tagged [multiple-database]
11 questions
2
votes
2 answers
Does it matter which database you connect to when querying across multiple databases?
I'm building a Sharepoint application with Nintex workflow that runs a single SQL query over multiple databases (on the same MS SQL server). Does it matter which database I specify in the connection string in terms of speed?
So if my query looks…
Teebs
- 121
- 2
1
vote
2 answers
Scaling from Multiple Database to Single Database Architecture in SQL Server
My application is centered around self-contianed "workspaces". For many really good reasons (everything from management to security), we have always had a one-database-per-workspace architecture. Each database has identical schema, stored…
Peter Moore
- 113
- 6
1
vote
2 answers
How to scale with MySQL (when not ready to scale properly)
We are using MySql.
My situation
I have a large number of tables with millions of rows each. Those tables are updated every second and are used both for adding info and retrieving info. Each table can be 5GB or 10GB or even more.
I have one table…
Vicky Dallas
- 21
- 4
0
votes
1 answer
Alternative to multi-master replication between local and cloud db when writes are infrequent and only 1 db at a time
Background:
I have a closed-source app on my laptop that saves its data in a local SQLite database. I'm working on creating a mobile app for myself that would replicate the functionality of the desktop app, but run on mobile, consequently…
0
votes
0 answers
Separating a single database into one user/transaction database and one time series database
My project involves storing sensor data (time series data) in db. There are about 5,000 sensors, each is sending data at 15 min to 1 hour interval. The existing service is using a single db, storing all frontend user, transaction and sensor data.…
0
votes
0 answers
Handling multiple users/ databases in postgres
Whats the best way to organize seperate companies/users in postgres?
I've developed a multi user platform, where users have access to only their companies data. I'm no DB engineer and initially the project was only for one user, but now I've had…
Lewis Morris
- 101
- 2
0
votes
1 answer
How do I set up one server to replicate X schemas from X different server, without resorting to mysqldump?
In other words; I'm trying to figure out how to restore multiple mariabackup dumps to one server (different databases). I assume I'm missing something obvious in the documentation, but I've been looking for months with no luck.
I have a number of…
Vonsild
- 101
- 2
0
votes
1 answer
Linking foreign keys across multiple databases: direct, or using an intermediary table?
I want to make a part of my application reusable, and that warrants moving the corresponding tables into a separate database. So for the sake of an example, please consider the two imaginary databases in the list that follows. (More databases…
ᴍᴇʜᴏᴠ
- 121
- 1
- 6
0
votes
1 answer
I dont know where to begin: mysql select with inner selects on iterations too slow with bigger tables ( 4 tables on 2 databases)
Kontext is easy:
A) A [discussion-thread.db1] has many [Posts.db1]
B) each Post has an [author.db2] and 1 to 10 [attachments.db1]
Additional Information:
discussion, posting & attachment's-meta-data are on one database - the details of the…
flowfab
- 5
- 3
0
votes
1 answer
SQL SERVER: Header Blocker Across Multiple Databases with wait type CXCONSUMER
We have an instance of SQL Server which has multiple databases. A process in one database seems to be blocking a process in another database. When I look in activity monitor I can see a header blocker (A one in the header blocker column). This seems…
SQLMIKE
- 437
- 1
- 5
- 10
-1
votes
2 answers
Merging Data From Multiple Tables With Nesting/Loops
Long story short I need to replace a website component with a newer one. Problem is the way the old one stored information in the database is very convoluted.
I have a new empty table (for the new component) with 3 columns:
| field_id | item_id |…
rudiments
- 7
- 2