PC Review


Reply
Thread Tools Rate Thread

database performace bad - very slow querys

 
 
Silas
Guest
Posts: n/a
 
      21st Jul 2003
with over 450,000 records and about 24 fields I know it
will be slow but how could I speed it up without
upgrading to SQL Server. I already compacted and it
didn't do much
 
Reply With Quote
 
 
 
 
Eric
Guest
Posts: n/a
 
      21st Jul 2003
Hi,

With the amount of records you're talking about, there
wouldn't much performance gain in whatever you try.

Some suggestions:

-Eliminate some fields (probably not your preferred choice)
-Have only one user working with the database at once (If
this file is on a network, only have one person at a time
using the database will significantly speed performance)
-If you have forms, keep them very very simple
-Avoid excessively long dropdowns

These most likely won't do very much, but it's something
to try. But with the number of records you have, and
assuming they'll keep adding up, I strongly suggest you
migrate to a SQL Server database.

Regards,
Eric

>-----Original Message-----
>with over 450,000 records and about 24 fields I know it
>will be slow but how could I speed it up without
>upgrading to SQL Server. I already compacted and it
>didn't do much
>.
>

 
Reply With Quote
 
Kevin @ 3NF
Guest
Posts: n/a
 
      21st Jul 2003
What part is slow? Initial form load? Querying? Other?

Is the table indexed? Properly?

Is it on a network? Local HD?

Some details, please...

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm



"Silas" <(E-Mail Removed)> wrote in message
news:08d401c34f90$29e00ce0$(E-Mail Removed)...
> with over 450,000 records and about 24 fields I know it
> will be slow but how could I speed it up without
> upgrading to SQL Server. I already compacted and it
> didn't do much



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Vista 64 Slow Performace Sametime Each Week Rick Rogers Windows Vista Performance 0 6th Feb 2009 11:40 AM
Re: Vista 64 Slow Performace Sametime Each Week Rick Rogers Windows Vista Performance 1 9th Sep 2008 12:47 PM
Re: Vista 64 Slow Performace Sametime Each Week Kayman Windows Vista Performance 0 9th Sep 2008 08:05 AM
Help with slow print performace Clayton Windows XP General 3 21st Jan 2005 01:29 AM
Slow performace in Outllook 2002 after installing XP SP1 =?Utf-8?B?emlv?= Microsoft Outlook Discussion 2 4th Jan 2004 06:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:43 AM.