close
Comments you submit will be routed for moderation. If you have an account, please log in first.
Modify

Opened 2 years ago

Last modified 15 months ago

#312 accepted task

Investigate possibility to use sqlite for mail indexing/storing

Reported by: damato Owned by:
Priority: low Milestone: YAM future release
Component: mail indexing Version:
Severity: major Keywords:
Cc: OS Platform:
Blocked By: Blocking:
Release Notes:

Description

Phenomenon

Currently YAM saves each mail in a separate file using an index file to quickly find mail throughout the filesystem. It might be, however, a better approach to use perhaps an SQL based approach (e.g. using 'sqlite').

Background analysis

On AmiNET there exists an amiga port of sqlite 3.6.1 (http://aminet.net/package/biz/dbase/sqlite-3.6.1-amiga) which might be a good basis for a test.

Implementation recommendation

A prototype have to be created where several thousands emails should be stored and indexed in a basic SQL database using sqlite. Performance tests against the current solution should be made and based on these performance tests the prototype should be converted into code usable for YAM (or not).

Attachments (0)

Change History (2)

comment:1 Changed 15 months ago by damato

  • Milestone changed from YAM 2.9 to YAM future release

comment:2 Changed 15 months ago by damato

  • Status changed from new to accepted

Add Comment

Modify Ticket

Action
as accepted .
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.

This list contains all users that will be notified about changes made to this ticket.

These roles will be notified: Reporter, Owner, Subscriber

  • Jens Maus(Reporter, Participant)