Best Pratice to work with thousand of users

Question

1.00/5 (1 vote)

See more:

Hi all,

I want to discuss with you my one of scenario and want to know the best practice to make it faster and easy.

Suppose, I have one Users table and I have 15,000 Users available in this table, I have one page in which, I can upload only existing users to assign them something, Now here, I want to check that all uploaded users must be exist in the system,

Currently what I am doing!

I am getting all uploaded users email address and join them by "," and pass through SP.

I having split function in DB and I am checking by IN operator in SQL query.
Like "SELECT * FROM USERS WHERE EMAIL IN(SELECT VALUE FROM SPLITFUNCTION(',',@ALLEMAILS))"
and return all existing users.

suppose, If I have 10,000 users in excel sheet then Is it good thing to collect all email address, combine them in string object and pass it into SP?

Option 2
If I get all users from db then every time it will retrieve 15000 users from DB even if I just want to check only 1 or 10 users.

I want to know the other good options except above two,

Note: can not use cache,cookie, etc to store data in server object,

Posted 4-Dec-13 18:56pm

Imran Khan Pathan

Updated 4-Dec-13 19:14pm

Sergey Alexandrovich Kryukov

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 5-Dec-13 1:14am

If you develop an ASP.NET site, have database (you say "SQL"), why using such trash as "Excel sheet"? No good.
Despite one question mark, this post is not a question, its purpose is not quite clear.
And, by the way, some thousands users is not many, not at all. I don't understand how it possibly can raise a performance concerns.
—SA

Imran Khan Pathan 5-Dec-13 1:52am

Yes, I have asp.net site, I have import action in the page, let me explain you in detail.

In my website, many companies can create their account and can upload all employee details, so it is a bed thing to insert one by one employee by a single form, rather then we provided a action to import all employee by uploading excel sheet.

Now in other page, suppose, I have question answer page for particular company, so company can create many questions and they can decide which employee should part of that question. so during creation of questions, company needs to select employees, company can select their employee either from the list or by uploading excel sheet again so in case if company choose to upload excel sheet again then we need to check that all employee should already part of that company.

thatraja 5-Dec-13 10:53am

To reply someone, use 'Reply' button/widget. Only that way you could send notification to appropriate person.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)