Question Re: files in SQL Anywhere in Technology Q&A

files in SQL Anywhere

Former Member — Fri, 22 Jul 2011 12:07:20 GMT

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 ?

Re: files in SQL Anywhere

MCMartin — Fri, 22 Jul 2011 12:10:28 GMT

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

Re: files in SQL Anywhere

Former Member — Fri, 22 Jul 2011 14:24:48 GMT

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?

Re: files in SQL Anywhere

MCMartin — Mon, 25 Jul 2011 03:13:09 GMT

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.

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 05:03:27 GMT

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

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 05:07:26 GMT

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:

Unloading/reloading the database (e.g. with the help of dbunload - that might even decrease the file size)
Defragmenting the file/disk (e.g. by using SysInternals's Contig tools)
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...

Re: files in SQL Anywhere

Breck_Carter — Mon, 25 Jul 2011 06:17:26 GMT

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

Re: files in SQL Anywhere

Breck_Carter — Mon, 25 Jul 2011 06:18:29 GMT

I swear I did not delete it 🙂

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 06:44:38 GMT

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

Re: files in SQL Anywhere

MarkCulp — Mon, 25 Jul 2011 07:33:25 GMT

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?

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 07:55:38 GMT

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...

Re: files in SQL Anywhere

graeme_perrow — Mon, 25 Jul 2011 09:10:06 GMT

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?"

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 12:15:50 GMT

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:

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 10:17:12 GMT

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

Re: files in SQL Anywhere

MarkCulp — Mon, 25 Jul 2011 10:57:17 GMT

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!

Re: files in SQL Anywhere

VolkerBarth — Mon, 25 Jul 2011 11:53:08 GMT

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.

Re: files in SQL Anywhere

Breck_Carter — Mon, 25 Jul 2011 15:16:43 GMT

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