General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>Either way you look at it you are flirting with disaster if your memos are that large. If you have a dbf, fpt or cdx over 2 gig you should consider either redisigning your schema to scale better or use another data engine that doesn't have the size limitation of a dbf/fpt structure, IMO.
>>
>>Hi Eric,
>>
>>In pursuit of 'another data engine', I just priced SQL Server 2000 at $4678, which I dont think my client will swallow...
>>
>>I am going to try to store the data as character records in a table, copy them into an edit box for editing, then strip out carriage returns etc. and save each line as a record back to the table.
>>
>>I tried to find something that does this in the 'download' section of the UT but was unable.
>>
>>Thanks for your help.
>
>You can also use MSDE which is the SQL Server data engine. I don't know whats it's limitations are, if any.
>
>You could also try using a compression utility.
Eric;
I think the MSDE route is more restrictive with a 2 gig limit for the dbc or a table. So you can have two tables of 1 gig each and you hit the limit. It does have its uses thought.
Tom
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only