Click here to Skip to main content
15,867,871 members
Home / Discussions / Database
   

Database

 
GeneralRe: Is this SQL query about getting information from all forum users' unread PMs? Pin
Member 126624485-Aug-16 9:14
Member 126624485-Aug-16 9:14 
QuestionSearching for the right database Pin
Kogs-7927-Jul-16 3:04
Kogs-7927-Jul-16 3:04 
SuggestionRe: Searching for the right database Pin
Richard MacCutchan27-Jul-16 4:56
mveRichard MacCutchan27-Jul-16 4:56 
GeneralRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:42
Kogs-7927-Jul-16 23:42 
QuestionRe: Searching for the right database Pin
User 1106097927-Jul-16 20:33
User 1106097927-Jul-16 20:33 
AnswerRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:56
Kogs-7927-Jul-16 23:56 
AnswerRe: Searching for the right database Pin
Bernhard Hiller27-Jul-16 21:11
Bernhard Hiller27-Jul-16 21:11 
GeneralRe: Searching for the right database Pin
Kogs-7927-Jul-16 23:37
Kogs-7927-Jul-16 23:37 
Thanks for your reply.
- the keys are all in uppercase in both tables, so a case sensitive match works perfect.
- The first table is the leading data store, the second table is more or less a lookup table. I want to check which entries in the lookup table exists also in the data store table.
- I don't need to search for any values, I need to search only for keys.
- If a key in the first table already exists, I need to update the value (increase the value)
- If a key in the second table already exists, nothing happens, just continue with the next one. But inserting doublicated entries in the secend table are extremly unlikely, so there is no need to check them. It's no problem if for some reason there are really doublicates, to add them twice. But if I use a rdbms and define the key as PK, this check is done automatically.

I will give it a try with a rdbms (not MS SQL because I want it to be available also on Linux systems).
But I'm wondering if a simple NoSQL DB (simple key/value) store meight not be faster in this case. I don't have much experience with NoSQL dbs, but I think they exist for a reason. And I want a really lightning fast solution Wink | ;-)
But if you think a normal sql db can be as fast (or faster) than I give it a try.

GeneralRe: Searching for the right database Pin
Jörgen Andersson31-Jul-16 5:27
professionalJörgen Andersson31-Jul-16 5:27 
Questioncannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya20-Jul-16 22:29
Vinny Ardhya20-Jul-16 22:29 
AnswerRe: cannot use "dynamic" Connection String with Excel? Pin
Victor Nijegorodov23-Jul-16 9:27
Victor Nijegorodov23-Jul-16 9:27 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya24-Jul-16 15:58
Vinny Ardhya24-Jul-16 15:58 
AnswerRe: cannot use "dynamic" Connection String with Excel? Pin
Peter_in_278024-Jul-16 16:36
professionalPeter_in_278024-Jul-16 16:36 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Vinny Ardhya24-Jul-16 17:15
Vinny Ardhya24-Jul-16 17:15 
GeneralRe: cannot use "dynamic" Connection String with Excel? Pin
Richard MacCutchan24-Jul-16 20:54
mveRichard MacCutchan24-Jul-16 20:54 
QuestionEncrypt email address to 6-8 digit alphanumeric Pin
sumit703418-Jul-16 22:55
sumit703418-Jul-16 22:55 
AnswerRe: Encrypt email address to 6-8 digit alphanumeric Pin
Richard MacCutchan19-Jul-16 3:14
mveRichard MacCutchan19-Jul-16 3:14 
Generalmovement of foreign key Pin
Member 1141876917-Jul-16 12:56
Member 1141876917-Jul-16 12:56 
GeneralRe: movement of foreign key Pin
User 1106097917-Jul-16 23:10
User 1106097917-Jul-16 23:10 
QuestionRestore CDC Data Pin
maryam.saboor16-Jul-16 19:39
professionalmaryam.saboor16-Jul-16 19:39 
AnswerRe: Restore CDC Data Pin
maryam.saboor18-Jul-16 18:54
professionalmaryam.saboor18-Jul-16 18:54 
QuestionMySQL - Update a table from same table using SELECT Pin
Jassim Rahma16-Jul-16 11:54
Jassim Rahma16-Jul-16 11:54 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
Mycroft Holmes16-Jul-16 13:38
professionalMycroft Holmes16-Jul-16 13:38 
AnswerRe: MySQL - Update a table from same table using SELECT Pin
User 1106097917-Jul-16 1:37
User 1106097917-Jul-16 1:37 
GeneralRe: MySQL - Update a table from same table using SELECT Pin
Jassim Rahma17-Jul-16 3:00
Jassim Rahma17-Jul-16 3:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.