Andy
Fri Apr 11 07:42:12 CDT 2008
This is a multi-part message in MIME format.
------=_NextPart_000_002C_01C89BD9.D85B9BF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The table could have any number of fields (of differing types) as it =
will be defined by the user to suit the type of information that is =
going to be stored within it.
I would image there could be in excess of about 1.5 milliion records=20
"AtoutFox 37" <fox_at_ater.net> wrote in message =
news:%234sDKH9mIHA.6064@TK2MSFTNGP03.phx.gbl...
The answer is it depends on a lot of factors that we don't know to be =
able to answer, factors like :
a.. Number of records of the database (tables with less than 30000 =
records will be slower with Indexes)=20
b.. Number and types of fields of the tables in the DB=20
c.. Ratio between writings and readings (the more indexes you've got =
the longer the writings will be but the quicker the readings will be ...
"Andy Trezise" <andy@work.com> a =E9crit dans le message de groupe =
de discussion : #2Gwo66mIHA.944@TK2MSFTNGP05.phx.gbl...
> Hi, quick question...
>=20
> I'm just beginning to develop a document management/retrieval =
system using=20
> VFP9 & SQL. The main purpose of the program is to allow users the=20
> flexibility to search
> for any piece of data by ANY of the numerous fields in the =
database. I am=20
> using paramatised views to retrieve information from the =
underlying
> tables.
>=20
> My question is, do I need to create an index for each of the =
fields on the=20
> remote table given that the user can search on any one (or =
combination) of
> them? What performance benefits will I get from doing so?
>=20
>
------=_NextPart_000_002C_01C89BD9.D85B9BF0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.6000.16640" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-TOP: 15px"=20
bgColor=3D#ffffff leftMargin=3D0 topMargin=3D0 name=3D"Compose message =
area"=20
CanvasTabStop=3D"true">
<DIV><FONT face=3DArial size=3D2>The table could have any number of =
fields (of=20
differing types) as it will be defined by the user to suit the type of=20
information that is going to be stored within it.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I would image there could be in excess =
of about 1.5=20
milliion records </FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"AtoutFox 37" <fox_at_ater.net> wrote in message <A=20
=
href=3D"news:%234sDKH9mIHA.6064@TK2MSFTNGP03.phx.gbl">news:%234sDKH9mIHA.=
6064@TK2MSFTNGP03.phx.gbl</A>...</DIV>
<DIV><FONT face=3DArial>The answer is it depends on a lot of factors =
that we=20
don't know to be able to answer, factors like :</FONT></DIV>
<UL>
<LI><FONT face=3DArial>Number of records of the database (tables =
with less=20
than 30000 records will be slower with Indexes)</FONT>=20
<LI><FONT face=3DArial>Number and types of fields of the tables in =
the=20
DB</FONT>=20
<LI><FONT face=3DArial>Ratio between writings and readings (the more =
indexes=20
you've got the longer the writings will be but the quicker the =
readings will=20
be ...<BR></FONT><BR><BR><BR>"Andy Trezise" <andy@work.com> a =
=E9crit=20
dans le message de groupe de discussion :=20
#2Gwo66mIHA.944@TK2MSFTNGP05.phx.gbl...<BR>> Hi, quick=20
question...<BR>> <BR>> I'm just beginning to develop a =
document=20
management/retrieval system using <BR>> VFP9 & SQL. The main =
purpose=20
of the program is to allow users the <BR>> flexibility to =
search<BR>>=20
for any piece of data by ANY of the numerous fields in the database. =
I am=20
<BR>> using paramatised views to retrieve information from the=20
underlying<BR>> tables.<BR>> <BR>> My question is, do I =
need to=20
create an index for each of the fields on the <BR>> remote table =
given=20
that the user can search on any one (or combination) of<BR>> =
them? What=20
performance benefits will I get from doing so?<BR>>=20
<BR>></LI></UL></BLOCKQUOTE></BODY></HTML>
------=_NextPart_000_002C_01C89BD9.D85B9BF0--