Text-delimited Database

Results 1 to 2 of 2

Thread: Text-delimited Database

  1. #1
    Join Date
    Dec 1969

    Default Text-delimited Database

    I have a software delivery system that sends out software on my company&#039s intranet. After the delivery the system let the pusher (user who is pushing the software) know if the software was successfully pushed or it failed. This data is coming from the unix server. Currently the data is coming in the form of text (csv) files. The data tells us that which hostname received the software and which failed<BR><BR>The management uses my asp page to access this text file and know which hostname received the software sucessfully and which failed. Looking at the no of softwares being pushed to all the servers this text file is growing like crazy. Right now it has about 30,000 rows and expected to grow more. Due to this the search becomes slow. So what should i do to make this search faster.<BR><BR>Database table?<BR>Create a table which gets the data feeded directly from the unix servers...how do I do that? Every time user pushes the software and delivery is over...I want the data to come from unix to my table and get appended. How to do that. <BR><BR>Also I am using SQL 7.0 . Will my database will really suffer if I have a table which has about 50000 rows? And more than one user are querying while system is feeding the data to it. If this is the case then would it be just better to keep the text file growing?<BR><BR>Please help!

  2. #2
    Scott S Guest

    Default RE: Text-delimited Database

    I dont know much about using text files as data sources for ASP, but as for SQL 7 databases, i believe that it should be able to easily handle a 50K row table. UNISYS used a SQL 7 Database with 2 TeraBytes of data in it for demo purposes, thats much much more than 50K rows. The commercial databases are meant to house millions of rows. Look at all the books available on Amazon.com, they are nothing more than entries into a table, & there are millions of them

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts