About a table size

Dev Shed Forums Sponsor:

November 17th, 2003, 04:24 AM

goreXP

Contributing User

Join Date: Jun 2003

Location: Bucharest

Posts: 72

Time spent in forums: 2 h 18 m 28 sec
Reputation Power: 10

About a table size

Q: Since the whole database is contained in "one big file", can I use one table/year or should I split it in one table/month?
(a month is about 20.000 to 50.000 records)

November 18th, 2003, 02:21 PM

badukist

Contributing User

Join Date: Jun 2003

Posts: 62

Time spent in forums: 13 h 3 m 18 sec
Reputation Power: 11

If you use parametrized queries, no matter
We have hundreds of thousands of records in one table, but, at client level, record sets are filtered using parameters.
Usualy a day, or, if he wants, more, but he must specify start date and end date.

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > About a table size

« Previous Thread | Next Thread »

Developer Shed Advertisers and Affiliates

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	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 vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump