I would say creating 17,000 tables with two rows/values is a bad idea.
Instead there should be one table (pseudo sql follows.)
create table theTable
(
select_name primary varchar(256),
message_line int,
message_text varchar(80)
);
Each file would produce a different 'select_name'. Then the message_line =
0 would correspond to your first message and message_line=1 would correspond
to the second message. If you actually need a variable number of lines per
'message' then you can go with a two table solution (ask if this isn't
clear.)
With a correctly configured database (say oracle using a 'index' table) the
database could even keep the entire table in memory.
> Behalf Of Rajil Saraswat
>
>
> thanks for pointing out the database list.
> well, u can consider the files as a measure of the size. the database
> required will have the same number of tables as there are files. in each
> table there will be two values(text messages)
> The html page will query the database and will have to produce the texts
> from the file and send it to the browser.
> this is a short description. so what do u say?
>
> On 05/17/00, ""Joe Schell" <[EMAIL PROTECTED]>" wrote:
> > There is a database list. I am not sure if this belongs on that or not.
> >
> > I am not sure what you are referring to. Typically a database
> is measured
> > in number of tables, number of records, record size and total space
> > requirements. 'files' isn't a typical measurement.
> >
> > Do you want to put the names (paths) of 17,000 files in a database? And
> > then what? Dumping 17K names to a web page probably isn't a
> good idea. But
> > if that is what you want to do then just create a static html page and
> > forget the database. If not then you might want to provide more detail
> > about what you intend or are doing.
> >
> > > Behalf Of Rajil Saraswat
> > >
> > >
> > > hi everyone,
> > > We are in the process of setting up a website. We use a
> large number of
> > > files(17,000) whose size is not big. What database will be
> suitable for
> > > this under Linux. Further thru which scripting language should i
> > > interface
> > > this database.
> > > Thanks for all ur comments.
> > >
>
> ---
> You are currently subscribed to perl-win32-users as: [EMAIL PROTECTED]
> To unsubscribe, forward this message to
> [EMAIL PROTECTED]
> For non-automated Mailing List support, send email to
> [EMAIL PROTECTED]
>
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
