Dealing with table size limitations

Post Reply
b.sims
Posts: 99
Joined: Fri Oct 26, 2001 10:40 am

Dealing with table size limitations

Post by b.sims »

While going through the Texis specifications, I note that maximum table size for a 32-bit machine is 2GB. I wondered about people's experience in getting around this in common use. In my case, the use will be for indexing a large number of web pages. My test run of 10,000 pages added up to 100MB; I guess this means I will be able to have 200,000 with a 2GB limit.

I thought of several ways to do this, for example by dividing the pages up into categories and then running the search on them together.

Has anyone any experience of doing this sort of thing? I suppose I could also limit the amount of data received for each page, although this would affect functionality.

Help much appreciated,
Benjamin Sims
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

Dealing with table size limitations

Post by mark »

Most people switch to a platform where we have large file support such as Solaris 2.6 or above, Tru64 on the alpha, Linux 2.4 or above on Intel, FreeBSD, or Windows NT/2K/XP.

Another possibility to perform the same query against each table and sort the results together in a ram table or such. This obviously requires more horepower because you would be doing N queries and a sort for every user query.
b.sims
Posts: 99
Joined: Fri Oct 26, 2001 10:40 am

Dealing with table size limitations

Post by b.sims »

So, with a Windows Texis license I am thinking about an Itanium machine?
b.sims
Posts: 99
Joined: Fri Oct 26, 2001 10:40 am

Dealing with table size limitations

Post by b.sims »

So I could use larger than two-gig files with this? What is the cost involved?

If I use Linux rather than Windows for the server, will I see a substantial gain in performance?
b.sims
Posts: 99
Joined: Fri Oct 26, 2001 10:40 am

Dealing with table size limitations

Post by b.sims »

Do I need to buy a different license for the larger than two-gig files? At the moment I have ordered standard Texis, automatic growth.
Post Reply