i have a database sql anywhere 7 but the file .db have 1.8 gb, i know the limit is 2gb, this is true? also i know exist 12 files but, how do it ?

asked 22 Jul '11, 12:07

Enrique's gravatar image

Enrique
80125
accept rate: 0%

edited 25 Sep '11, 10:46

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819

Comment Text Removed
Comment Text Removed
1

Did someone down-vote this question? That's just not right, it is a legitimate question that deserves (and got) an answer.

(25 Jul '11, 15:16) Breck Carter

No the limit of 2 GB vanished with NTFS file system, even FAT32 will allow more. The 2GB limit holds only if the file system is still FAT.

Today I would expect that you are using NTFS under windows, so no 2 GB barrier anymore!

check SQLA limits

permanent link

answered 22 Jul '11, 12:10

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

applies to anywhere 7? because the database is slower day by day, then I have no problem if you pass the 2gb, and it is advisable to upgrade to a current version?

(22 Jul '11, 14:24) Enrique
Replies hidden

When I remeber correctly the limits mentioned above already applied to Version 7, anyway by upgrading to a current version you will gain a lot of good stuff.

(25 Jul '11, 03:13) Martin
Comment Text Removed

Strange thing: I added a comment and was about to edit it - and now it's gone... Please help, dear administrator...

(25 Jul '11, 05:03) Volker Barth
Replies hidden

I don't know for v7, but v8 surely states these limits as mentioned. For FAT32, the maximum file size is 4 GB.

Besides that, in case the recommended upgrading to a newer version is out of reach for some reason, you might also try to improve the database layout by the following means:

  1. Unloading/reloading the database (e.g. with the help of dbunload - that might even decrease the file size)
  2. Defragmenting the file/disk (e.g. by using SysInternals's Contig tools)
  3. Recreating indizes (though that is rarely needed with SQL Anywhere IMHO).

There's also a REORGANIZE TABLE statement to improve the storage of tables one by one, but I guess it's suuported for v8 and above...

(25 Jul '11, 05:07) Volker Barth

I swear I did not delete it :)

(25 Jul '11, 06:18) Breck Carter

Yes, I blame it solely on the undocumented "Monday morning auto delete function"...

(25 Jul '11, 06:44) Volker Barth

I see from the admin log that Volker made a comment about three hours ago and someone deleted it also about three hours ago... but I cannot tell who?

(25 Jul '11, 07:33) Mark Culp
Comment Text Removed

Well, I was about to edit the comment immediately after creating it. But possibly I just clicked on the wrong button (though "edit" and "delete" are not direct neighbours) - and it would need a remarkable lack of coffee when I would have accidentally confirmed the delete question, too... Correction: No, it wouldn't need that lack as there is no confirmation dialog...

Some things just have to stay mysterious:)No, I guess then it's simply that I chose the wrong button - unless other evidence comes up...

(25 Jul '11, 07:55) Volker Barth

There is no confirmation dialog for editing, but there should be one for deleting. It is still on my list to change the confirmation dialog to indicate what you are trying to do, i.e. "Are you sure you want to delete this comment?" rather than "Are you sure?"

(25 Jul '11, 09:10) Graeme Perrow
Comment Text Removed

Well, when deleting a comment, there's no confirmation dialog at all - the delete works immediately. Cf. this image taken from a comment I have just recently deleted:

The comment

(25 Jul '11, 10:15) Volker Barth

Hm, I should've changed the image background colour - now I'm waiting for someone trying to click the "buttons" in the image above:)

(25 Jul '11, 10:17) Volker Barth

Yes, your previous comment is quite confusing... it took me a few seconds to figure out what had been done... I initially thought that there was a bug in the forum that was being exposed!

(25 Jul '11, 10:57) Mark Culp

Well, I'd like to change the background colour (I even did in the local image file) - but unfortunately, now it's too late to edit my comment.

Sigh.

(25 Jul '11, 11:53) Volker Barth
showing 2 of 13 show all flat view

From the SQL Anywhere 7 Help...

ASA Reference 
  CHAPTER 13. Physical Limitations     
    Size and number limitations

File size (FAT 12)
16 MB

File size (FAT 16)
2 GB

File size (FAT 32)
4 GB

File size (NTFS, HP-UX 11.0 and later, Solaris 2.6 and later)
256 GB (for 1K pages)
512 GB (for 2K pages)
1 TB (for 4K pages)

File size (all other platforms and file systems)
2 GB
permanent link

answered 25 Jul '11, 06:17

Breck%20Carter's gravatar image

Breck Carter
32.5k5417261050
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×23
×15
×13
×7

question asked: 22 Jul '11, 12:07

question was seen: 2,902 times

last updated: 25 Sep '11, 10:46