<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'>Either are possible. I’ve used both,
mostly postgres for its rich feature set, but mysql for web applications that
don’t care about a rich database feature set. <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'>If you don’t plan to be a database
administrator MySQL is probably a better choice, but then, if your going to be
loading million plus row tables, you might want a DBA or learn how to be one. MySQL
out of the can typically outperforms postgres, but Postgres has more
performance tuning features, and so if you were interested in controlling
things like physical storage based on application keys, Postgres is a better
bet. <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'>In drupal 6, you’ll get stronger drupal
support in MySQL. I think the jury is still out on postgres. <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'>My point really was to not advise you on
which to use, but to warn you against designing storage optimization in PHP applications.
That is something that’s best done in the DB layer<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'>Dave<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'> Austin Einter
[mailto:austin.einter@gmail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Monday, March 07, 2011 3:32
PM<br>
<b><span style='font-weight:bold'>To:</span></b> support@drupal.org<br>
<b><span style='font-weight:bold'>Cc:</span></b> Metzler, David<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'>Metzler<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'>Thanks for advice. <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'>Out of all databases as of now Drupal is compatible with, which one is
suitable for high row counts and better performance during search, is it
postgres? Currently I am using MySQl (5.5.8), will it scale up to high row
counts.<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'>Best 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'> <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'><br>
<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'>On Mon, Mar 7, 2011 at 9:42 PM, Metzler, David <<a
href="mailto:metzlerd@evergreen.edu">metzlerd@evergreen.edu</a>> wrote:<o:p></o:p></span></font></p>
<div vlink=blue link=blue>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>I would advise against that. </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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. </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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. </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'> </span></font><o:p></o:p></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>
</span></font></div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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'> <a href="mailto:support-bounces@drupal.org"
target="_blank">support-bounces@drupal.org</a> [mailto:<a
href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>]
<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> <a
href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><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>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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"
target="_blank">techlists@ade.pt</a>> wrote:<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'>> <<a
href="mailto:techlists@ade.pt" target="_blank">techlists@ade.pt</a> <mailto:<a
href="mailto:techlists@ade.pt" target="_blank">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='mso-margin-top-alt:auto;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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><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 style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
</div>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a>
]<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>
</body>
</html>