Erwin Craps
Erwin.Craps at ithelps.be
Thu Sep 4 13:44:17 CDT 2003
No, the bigger the file the slower the system is rather the definition... XP changes size page file automaticly, if you have a very big pagefile would mean that you do not have sufficiant RAM. A pagefile are pieces of RAM moved to file due to not enough RAM. But most of the time the page file has about the same size as your RAM or more. A page file between 400 and 800 MB is normal. Spreading the page file over multiple physical disks does improve performance (in case of IDE not on the same controller) Well infact it does not improve performance, but it does 'brake' less on the system. Enough RAM is not a (positive) performance improvement, its rather removing the break on your CPU. Insufficiant RAM is like putting your feat on the speed pedal of a car while pushing your break at the same time... Adding RAM removes your feat from the break... Same thing for spreading the page file over physical disks. A disk can only access one location at the time. If you have a database and a page file on the same disk it accesses one or the other but not both at the same time. Thats another reasons why SCSI is way better then IDE (ATA). IDE only permits one access at a time per controller. SCSI permits multiple access per controller. Erwin Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, September 04, 2003 8:02 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Query Results Too Big? Guess I'll just leave those two files alone. Actually wouldn't performance be enhanced the larger the swapping file is? Rocky ----- Original Message ----- From: "Charlotte Foust" <cfoust at infostatsystems.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Thursday, September 04, 2003 10:31 AM Subject: RE: [AccessD] Query Results Too Big? > The page file can be changed by going to the System applet in the > control panel and selecting the Advanced tab. Click on Settings for > Performance Options, then select the advanced tabin the dialog. The > bottom section is Virtual Memory, and the Change button will allow you > to resize the paging file. If you have multiple drive, you can put a > small paging file (2MB) on C: and put a larger one on D:. > > Charlotte Foust > > -----Original Message----- > From: Bobby Heid [mailto:bheid at appdevgrp.com] > Sent: Thursday, September 04, 2003 9:15 AM > To: 'Access Developers discussion and problem solving' > Subject: RE: [AccessD] Query Results Too Big? > > > I don't think that you CAN delete the page file from within windows. > Nor do you want to. It is a file that the OS uses during its > operation. I am not sure about the other file. > > Bobby > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > Smolin > - Beach Access Software > Sent: Thursday, September 04, 2003 12:59 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Query Results Too Big? > > > Do you know if they can they be deleted? > > Rocky > > ----- Original Message ----- > From: "Bobby Heid" <bheid at appdevgrp.com> > To: "'Access Developers discussion and problem solving'" > <accessd at databaseadvisors.com> > Sent: Thursday, September 04, 2003 9:49 AM > Subject: RE: [AccessD] Query Results Too Big? > > > > One is your paging file, the other must store system data when > hibernating. > > > > Bobby > > > > -----Original Message----- > > From: accessd-bounces at databaseadvisors.com > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky > > Smolin - Beach Access Software > > Sent: Thursday, September 04, 2003 12:44 PM > > To: Access Developers discussion and problem solving > > Subject: Re: [AccessD] Query Results Too Big? > > > > > > I'm using WXP and I don't see a WINNT folder. But I do see two > > files > named > > hiberfil.sys and pagefil.sys which, together are almost 1GB. Any > > idea > what > > they are? They were updated this AM when I turned on the machine. > > > > TIA > > > > Rocky > > > > ----- Original Message ----- > > From: "Erwin Craps" <Erwin.Craps at ithelps.be> > > To: "Access Developers discussion and problem solving" > > <accessd at databaseadvisors.com> > > Sent: Thursday, September 04, 2003 9:05 AM > > Subject: RE: [AccessD] Query Results Too Big? > > > > > > > This could be an os problem to... > > > > > > Check if in you temp folder (usualy c:\temp or c:\winnt\temp or > > > c:\windows\temp and/or C:\Documents and Settings\[USERNAME]\Local > > > Settings\Temp) you have a lot of temp files. > > > Delete everything in there (first close all apps). > > > > > > When using W9x you have a maximum of x files in a folder. It is > > > posible that you have to much lost files. > > > > > > I can also be a disk corruption. Scandisk your drive after > > > deleting those temp files. > > > > > > And while we are on the road, do a defrag... > > > > > > Erwin > > > > > > > > > -----Original Message----- > > > From: accessd-bounces at databaseadvisors.com > > > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, > > > Lambert > > > Sent: Thursday, September 04, 2003 5:54 PM > > > To: 'Access Developers discussion and problem solving' > > > Cc: 'bchacc at san.rr.com' > > > Subject: RE: [AccessD] Query Results Too Big? > > > > > > > > > Check these kBase articles. They might address your problem > > > > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;209940 > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;286153 > > > http://support.microsoft.com/default.aspx?scid=kb;en-us;161329 > > > > > > They all talk about the same problem, exceeding the > > > MaxLocksPerFile value and how to fix it. > > > > > > Lambert > > > > > > > -----Original Message----- > > > > From: Rocky Smolin - Beach Access Software > > > > [SMTP:bchacc at san.rr.com] > > > > Sent: Thursday, September 04, 2003 11:23 AM > > > > To: Access Developers discussion and problem solving > > > > Subject: Re: [AccessD] Query Results Too Big? > > > > > > > > Jim: > > > > > > > > I've got 3 1/2 GB free. That enough? Must be if the 2GB Access > > > > db limit is any indication. If the temp tables holding the > > > > query results > > > > > > > are inside the db then quite possibly is hitting the Access > > > > limit without using up all the hd space? It's a select query. > > > > > > > > Regards, > > > > > > > > Rocky Smolin > > > > Beach Access Software > > > > > > > > > > > > ----- Original Message ----- > > > > From: Jim Dettman <mailto:jimdettman at earthlink.net> > > > > To: Access Developers discussion and problem solving > > > > <mailto:accessd at databaseadvisors.com> > > > > Sent: Thursday, September 04, 2003 7:51 AM > > > > Subject: RE: [AccessD] Query Results Too Big? > > > > > > > > > > > > Rocky, > > > > > > > > << > > > > I have a query which is the record source for a report which > > > > eventually craps out with the message 'Not enough space on > > > > temporary disk' or some such. The query is joining 2 tables > > > > which > > > > > each have over 2 million records. > > > > >> > > > > > > > > What type of query is it? If it's creating a snapshot of the > > > data, > > > > then you could easily run out of disk space. How much free > > > > space do you have on your drive? I've done queries with > > > > 1,500,000 records without problems. > > > > > > > > << > > > > Is there a limit to how big a query result Access can generate? > > > Is > > > > there a setting to increase the limit? > > > > >> > > > > > > > > The only one I'm aware of is the 2048 table reference limit > > > and the > > > > fact that it must "compile" (Microsoft's term not mine) into a > > > > memory space slightly larger then 64K (they have never said how > > > > much larger). > > > > > > > > Jim Dettman > > > > President, > > > > Online Computer Services of WNY, Inc. > > > > (315) 699-3443 > > > > jimdettman at earthlink.net > > > > > > > > -----Original Message----- > > > > From: accessd-bounces at databaseadvisors.com > > > > [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky > > > > Smolin > > > > > > > - Beach Access Software > > > > Sent: Thursday, September 04, 2003 10:39 AM > > > > To: AccessD at databaseadvisors.com > > > > Subject: [AccessD] Query Results Too Big? > > > > > > > > > > > > Dear List: > > > > > > > > I have a query which is the record source for a report > > > which > > > > eventually craps out with the message 'Not enough space on > > > > temporary disk' or some such. The query is joining 2 tables > > > > which > > > > > each have over 2 million records. > > > > > > > > Is there a limit to how big a query result Access can > > > generate? Is > > > > there a setting to increase the limit? > > > > > > > > I think I may have reached the limit of Access and am > > > looking now > > > > for other ways to give the user what they want. Short of going > > > > to MSDE. > > > > > > > > TIA > > > > > > > > Rocky Smolin > > > > Beach Access Software > > > > > > > > > > > > > > > > _____ > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > AccessD mailing list > > > > AccessD at databaseadvisors.com > > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > > Website: http://www.databaseadvisors.com > > > > > > > > << File: ATT7209042.txt >> > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com