<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I would advise against that. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Drupal.org is hosting probably over
500,000 users already and there hasn’t been a noticeable performance
problem with logging in. Modern databases such as Postgres work fine with large
row counts. They support feature like partitioning to make sure that the
data is stored in separate places on disk based the value of key fields.
Don’t make the mistake of thinking that in PHP you can out optimize a
database written for such activities. An index of 7 million integer uids is
still a pretty small file by todays standards. Solve performance problems
when and where they happen, and throw hardware and or database server feature
sets at the problem rather than trying to out-program the DB programmers. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The account profile is serialized data so
I wouldn’t store it there, particularly if you want to be querying it,
but you can write a custom module to store info that is not natively in the
user table there. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
support-bounces@drupal.org [mailto:support-bounces@drupal.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Kamal Palei<br>
<b><span style='font-weight:bold'>Sent:</span></b> Sunday, March 06, 2011 3:07
PM<br>
<b><span style='font-weight:bold'>To:</span></b> support@drupal.org<br>
<b><span style='font-weight:bold'>Cc:</span></b> adept techlists - kazar<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [support] Saving and
Retreiving Form Data</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Thanks Kazar<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>This option may not be suitable as the number of records are going to
be quite high.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Probably user name should be hashed and on that basis table name should
be selected to store, seach data for better performance.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I really appreciate your information, this is really usefull for small
to medium scale operations.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Regards<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><st1:City w:st="on"><st1:place w:st="on"><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Austin</span></font></st1:place></st1:City><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Mon, Mar 7, 2011 at 4:15 AM, adept techlists - kazar <<a
href="mailto:techlists@ade.pt">techlists@ade.pt</a>> wrote:<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>On 3/6/11 4:37 PM, Austin
Einter wrote:<br>
> Thanks Kazar<br>
> Just one quick question.<br>
> All users, user profile data etc are stored in a single table in<br>
> Database or per user one table is created.<br>
> Is there any limit for maximum number of users.<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>There is a single "users" table<br>
<br>
As far as I know there is no limit (but I am far from expert at Drupal),<br>
other than hardware and memory settings that will need to be sufficient<br>
if you have many users logged in at once.<br>
<font color="#888888"><span style='color:#888888'><br>
kazar</span></font><o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
><br>
> On Sat, Mar 5, 2011 at 7:24 PM, adept techlists - kazar<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>> <<a href="mailto:techlists@ade.pt">techlists@ade.pt</a>
<mailto:<a href="mailto:techlists@ade.pt">techlists@ade.pt</a>>>
wrote:<br>
><br>
> On 3/3/11 9:56 PM, Austin Einter wrote:<br>
> > Hi All<br>
> > I have a requirement, where I need to have a form and
expected<br>
> fields<br>
> > are -<br>
> > Name<br>
> > Contact number<br>
> > Email ID<br>
> > Resume (File upload)<br>
><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>> Why
not just add fields to the user's account profile? This way<br>
> the info<br>
> can be retrieved and updated by them (or viewed/edited by
site<br>
> admin or<br>
> other users depending on permissions)<br>
><br>
> If you upgrade to Drupal 7 you can add fields to the user
profile (see<br>
> "Administer User Profile" <a
href="http://drupal.org/node/874026" target="_blank">http://drupal.org/node/874026</a>
). This is<br>
> part<br>
> of the core install and requires no further modules.<br>
><br>
> For Drupal 6 there is the Profile module (see<br>
> <a href="http://drupal.org/node/23710" target="_blank">http://drupal.org/node/23710</a>
)<br>
><br>
><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>--<o:p></o:p></span></font></p>
<div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>[ Drupal support list | <a href="http://lists.drupal.org/"
target="_blank">http://lists.drupal.org/</a> ]<o:p></o:p></span></font></p>
</div>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>