php - Suggestions on retrieving related data across databases with different logins? -


I have an array of user IDs in a query from Database A, Table A (AA).

I have the main user database in Database B, Table A (BA).

For each user ID returned in my result array from AA, I will name that user ID from first and last BA.

Different user accounts control each database. Unfortunately, not every login can be allowed for each database.

Q: How can I get the first and at least live with the questions and / or processing time? With 20 users in the array? With 20,000 users in the array?

P> Until the database is on the same server, just a Use Cross Databases. DB login, which is used to access data, will also need permission on both databases. Something like this:

SELECT AA.userID, BA.first, BA.last FROM databasename.schema.table AA Inner Job databasename.schema.table BA on AAUUZID = BA. AnswerID:

In response to comments:

I do not believe I have read many logins correctly, sorry . You can not use two different MySQL logins on one connection. If you need to do many queries, then in fact you have only three options: a) First run loop and multiple queries through the result set. B) Run a query using a WHERE clause with UserID in (@Fast Resetset) and pass it in the first result set. C) Select everything from the other DB and include them in the code.

All those three options are not very good, so I will ask, why can not you change the user permission on one of two DBS? I will also ask why, why would you have to choose the names and ID of 20,000 users? Unless it's some kind of data dump, I'm looking for a different way to display data that would be both easy to use and less query-intensive.

Everyone said, I use option B, with less than 1,000 records depending on the different options you choose. With a large number of records, I would probably use the C option and try to set two result sets in something that can be added (such as using array_combine)

< / Html>

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more