Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re^3: Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)( A DB won't help)

by mpeppler (Vicar)
on Jul 26, 2004 at 10:58 UTC ( #377389=note: print w/replies, xml ) Need Help??


in reply to Re^2: Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)( A DB won't help)
in thread Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)

Sybase could handle a million tables, but, as you say, the overhead (in syscolumns and sysobjects) would be tremendous.

BLOBS would be a bad idea from the space management perspective, and would probably be a bit slow as well due to being stored on a different page chain.

If you are using Sybase 12.5 or later and you know that the binary data will be less than a set amount (say 4k or so) then you could use a 4k or 8k page size on the server, and use a VARBINARY(4000) (for example) to store the binary data. This would be quite fast as it is stored on the main page for the row, and wouldn't waste any space.

Michael

  • Comment on Re^3: Combining Ultra-Dynamic Files to Avoid Clustering (Ideas?)( A DB won't help)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://377389]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (None)
    As of 2021-10-20 06:01 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?
      My first memorable Perl project was:







      Results (79 votes). Check out past polls.

      Notices?